Skip to Content
1
Former Member
Mar 28, 2013 at 04:43 PM

Subtotals in EPM reports

882 Views

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.