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.
