How to calculate sub average on Col 1 for item P1 and P2?
We need to calculate: Ave_Amt_P1 = Sum($20+$50+$30 in Col 4) / sum( 30+10+5 in Col 2) for item P1
Then, we need to find out the value in Avg_Amt who is twice up than value in Avg_Amt_P1.
Thanks in advance!
Jonathan Drummey's recent webinar might give you some insights on how to do this.
Retrieving data ...