I am facing issue in grand total for LAC-Calculation below is the table
I am trying to calculate impact of the product by using Level Aware calculation.
The first step I did is
running sum of product-1:
runningSum
(
({product-1}),
[mp ASC]
)
After the above calculation, the column E has the right result
Second step is to bring the overall value of the product-1 to all MPs through Level Aware calc:
Product-1 Total (LAC) (Column F): sum({product-1}, )
Now the column F from the above table provides the right result which is all columns contains value as 28
Third step is to identify the Cumulative Impact of Product-1:
Running sum of Product-1/sum(Product-1 Total (LAC))
Above calc provides the right number in all rows at the percentage level ( column G) but looking at the total it provides only 25% but it should give 100%.
Not sure why it is showing 25%.
Could someone please review my calculations and let me know what change should I do to bring 100% in grand total in column in G
Thanks,
Raja