Hello experts,
I have a report where in the row axis, we have a combination of Costcenter and Accounts (with suppression)... what is the best way to include a subtotal line after every CostCenter? Is there an EPM function to accomplish this? This subtotal line should be dynamic, based on the suppression...
For example:
CC1 Account 1
CC1 Account 2
CC1 Account 3
Subtotal $$$$$
CC2 Account 1
CC2 Account 4
Subtotal $$$$$
The subtotal lines above should expand with the CostCenter & Account selection, and should be displayed after every costcenter..
Your guidance is greatly appreciated.... Thanks in advance for your time and help!
Best regards,
VS.