Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ccmapple
New Contributor III

Pivot Table Rangesum and Above with 2 Dimensions

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!