I want to add hierachy view with three dimensions and percentage contribution from the overall number(measures)?

Question & Answer
1

On Selection of Pivot Visual, the visual should be initially should be created at MP level with percentage contribution like this

|MP|Product|Sales|WW Impact|
|US||10|40.00%|
|UK||15|60.00%|
|Total||25|100.00%|

Then by clicking on + symbol then the same above visual will be break down at MP and Product level with percentage contribution like below

|MP|Product|Sales|WW Impact|
|US|P1|5|14%|
||P2|5|14%|
|UK|P1|10|29%|
||P2|15|43%|
|Grand Total||35|100%|

I am able to bring the breakdown at MP and Product level, but could someone please help me how to bring percentage contribution which is WW impact that I mentioned above in the table.

For better understanding I have attached snapshot.
Quicksight

Thanks,
Raja

2

Hi Raja, can you please show me what your calculation looks like? If I do percentOfTotal(sum(Sales)), it works at all levels.

3

Hi @Imran_Burki ,

Thank you for your help. I use the percent of total calc, now I got the expected result.

Thanks,
Raja

1 Like