topic Pivot Table Rangesum and Above with 2 Dimensions in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Rangesum-and-Above-with-2-Dimensions/m-p/1319205#M409044 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am currently trying to get the Rangesum(Above()) for my Pivot table which comes with 2 dimensions.</P><P></P><P>Previously I am fine when using Rangesum(Above()) with only 1 dimension.</P><P></P><P>My requirement is to get the Gross Profit as shown in the image attached:</P><P></P><P>Attempt 1:&nbsp;&nbsp; RangeSum(Above(Sum(Amount),0,rowno()))</P><P>Result: I will get the Revenue figure. 26,053,123.08</P><P></P><P>Attempt 2:&nbsp;&nbsp;&nbsp; Above(Sum(Amount),2)</P><P>Result: I will get '-'</P><P></P><P>Can anyone give me some idea on how to get <STRONG>Revenue - Cost of Goods Sold</STRONG> as my Gross Profit.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 26 Apr 2017 06:31:06 GMT Anonymous 2017-04-26T06:31:06Z Pivot Table Rangesum and Above with 2 Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Rangesum-and-Above-with-2-Dimensions/m-p/1319205#M409044 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am currently trying to get the Rangesum(Above()) for my Pivot table which comes with 2 dimensions.</P><P></P><P>Previously I am fine when using Rangesum(Above()) with only 1 dimension.</P><P></P><P>My requirement is to get the Gross Profit as shown in the image attached:</P><P></P><P>Attempt 1:&nbsp;&nbsp; RangeSum(Above(Sum(Amount),0,rowno()))</P><P>Result: I will get the Revenue figure. 26,053,123.08</P><P></P><P>Attempt 2:&nbsp;&nbsp;&nbsp; Above(Sum(Amount),2)</P><P>Result: I will get '-'</P><P></P><P>Can anyone give me some idea on how to get <STRONG>Revenue - Cost of Goods Sold</STRONG> as my Gross Profit.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 26 Apr 2017 06:31:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Rangesum-and-Above-with-2-Dimensions/m-p/1319205#M409044 Anonymous 2017-04-26T06:31:06Z