This content has been marked as final. Show 8 replies
Need help in sorting out this solution.
Requirement is to create a Percentage KPI by both the dimensions grouped by Dim 1 & 2.
KPI is for every combination of Dim B we need to find percentage against Dim 1
i.e for Dim 1 row 1 = 10/(10+30+50)
Furthermore there is a need to calculate percentile as well.
Sample data below:
|Dim 1||Dim 2||Measure|