By using this website, you agree to our Terms of Use (click here)
A client has requested a detailed P&L formatted with subtotals per Account Class. I tried using Print Groups but when I do, the descriptions of the expanded Accounts do not print. I tried a number of other combinations of potential answers from the training material to no avail. How can this be done?
Thank you both for the answers. I've used the expanded Accounts quite extensively and it works beautifully. I was obviously not clear in my request.
I want to put the details of the Expanded account in Column B and then total the details in Column C.
I tested this and it is working for me, unless I am missing something. In the Row Set screen, click the lookup for the Data Source, select Account Class you want. In the bottom left, select Expand: Account and Row Description: Description.
Thanks for picking up this post DWS253. I lost track of it when I was out last week.
I also get the same behavior as you.
Set the Account Class to what you want, then set Expand to Account and Row Description to Description or Code-Description like this:
Then that one row should turn into multiple rows like my two rows pictured here below:
Something like this?
The key is the Column Group column in the Row Set and the Printing Group row in the Column Set. These fields are free form text so you can type whatever you want. The two just have to match for a row to print in a certain column.
Here is what I did on the Row Set:
And this is what I did on the Column Set:
Now, it's not really working because you'll notice in the screenshot above that Column A has a Printing Group value of COLB which means that the row descriptions only print for rows that display their values in the second column. For the Total Sales Revenue row, you'll notice that the "Total Sales Revenue" description didn't print. Only the number printed in Column C. I really need to put multiple values in the Column Group column in the Row Set (both COLB and COLC), but that doesn't work. I haven't figured out a way around this problem, but I'd love to hear any ideas.
It's a lot closer than I got! LOVE it! How about a fourth column for the Total descriptions to use the print group for the totals? But, that would mean that there is no indenting, just a separate column. Or, can there be a negative indent? I think I can work with that, though. Thank you!
Doesn't look like there can be a negative indent. I can't even type the negative symbol in the Indent column in the Row Sets screen.
But I think I figured out a way to do this. Thanks for pushing me. That's why I like having the ARC Forums. When I know that something is actually useful in the real world, it motivates me to keep digging.
I used the same Row Set as shown above, but then I did this on the Column Set:
Some notes about the screenshot:
- Note that there are now two Description columns. One prints for COLC rows (my total row) and one prints for COLB rows (my regular rows).
- The problem though with two Description columns is that the spacing gets really funny.
- So, I set the Printing Control on the second Description column (Column B) to be Hidden and then set the Printing Control on the first Description column (Column A) to be Merge Next and somehow that seems to work.
Here is what the result looks like. What do you think?
Excellent! I had tried the Merge/Hidden function but that was before you figured out the COLB/COLC so nothing was printing.
This is an excellent solution and very much appreciated!
Cool. I'd love to hear how things turn out for you.
Also, for some reason, whenever I see an Income Statement get broken into multiple columns like you're doing, it always makes me think of waterfall charts for some reason. Like this:
Note: I grabbed that screenshot from this website (click here).