Skip to Content

Subtotals by unique combinations of 2 or more dimensions in EPM report

Hi Experts,

We have a requirement where we have to display the subtotals by unique combinations of 2 or more dimensions of row axis.

I know how to achieve subtotal for each dimension but achieving this is the challenge we are facing.

For example. Below is my report layout,

Cost_Center | Account | Asset | 2019.TOTAL

CC1 | Acc1 | Asset1 | 300

CC1 | Acc1 | Asset2 | 400

CC1 | Acc2 | Asset1 | 300

CC1 | Acc2 | Asset2 | 600

CC2 | Acc1 | Asset1 | 200

CC2 | Acc1 | Asset2 | 500

CC2 | Acc2 | Asset1 | 100

CC2 | Acc2 | Asset2 | 500

If we give subtotal by Cost_Center and Account we get report like below

Cost_Center | Account | Asset | 2019.TOTAL

CC1 | Acc1 | Asset1 | 300

CC1 | Acc1 | Asset2 | 400

Sum 700

CC1 | Acc2 | Asset1 | 300

CC1 | Acc2 | Asset2 | 600

Sum 900

Sum 1600

CC2 | Acc1 | Asset1 | 200

CC2 | Acc1 | Asset2 | 500

Sum 700

CC2 | Acc2 | Asset1 | 100

CC2 | Acc2 | Asset2 | 500

Sum 600

Sum 1300

We are requiring report to look like

CC1 | Acc1 | Asset1 | 300

CC1 | Acc1 | Asset2 | 400

Sum 700

CC1 | Acc2 | Asset1 | 300

CC1 | Acc2 | Asset2 | 600

Sum 900

CC2 | Acc1 | Asset1 | 200

CC2 | Acc1 | Asset2 | 500

Sum 700

CC2 | Acc2 | Asset1 | 100

CC2 | Acc2 | Asset2 | 500

Sum 600

Please let me know your views on this

Below screenshot might help in visualizing.

capture.png (46.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11 at 10:58 AM

    Hi All,

    I was able to achieve this.

    I basically applied subtotal only on Account and got what was needed.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • May 11 at 09:37 AM

    Sorry, but your explanation is not clear!

    Please provide a test report screenshot! With full details!!!

    Add comment
    10|10000 characters needed characters exceeded