Grand total is not providing exact numbers through the usage of Level aware calculation

Question & Answer
1

I am facing issue in grand total for LAC-Calculation below is the table

LAC-1
LAC-11010×382 21.9 KB

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

2

@Raja - Thank you for posting your query. I was able to re-create the scenario and get the correct numbers at my end with similar calculated fields. Please see the details below. Hope this helps!

image
image902×543 48 KB

Runningtotal calculation:

runningSum(sum(Sales), [Segment ASC])

Impact Calculation

Runningtotal/sumOver(sum(Sales), , POST_AGG_FILTER)

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

3

Hi @sagmukhe,

Thank you for your helping on the calculation. It works for me.

Thanks again,
Raja