Dear All,
I am currently trying to get the Rangesum(Above()) for my Pivot table which comes with 2 dimensions.
Previously I am fine when using Rangesum(Above()) with only 1 dimension.
My requirement is to get the Gross Profit as shown in the image attached:
Attempt 1: RangeSum(Above(Sum(Amount),0,rowno()))
Result: I will get the Revenue figure. 26,053,123.08
Attempt 2: Above(Sum(Amount),2)
Result: I will get '-'
Can anyone give me some idea on how to get Revenue - Cost of Goods Sold as my Gross Profit.
Thanks in advance!