https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot/m-p/1689193#M52600 <P>Hi Qlik Community,</P><P>I have attached an image which shows the problem and required result Excel. The measure is the count of contribution which is calculated as count(contribution). I have 2 questions:</P><P>1. I need to present it in the form of a pivot as shown in the image with the heading "Query".</P><P>2. Once the first problem is solved, I need to show row-wise sum as shown in the image with the heading "Required Result".</P><P>Please note that values highlighted in yellow are to be excluded.</P><P>I would really appreciate the help. Thanks</P><P>&nbsp;Kashif</P> Thu, 23 Dec 2021 18:19:25 GMT kash04kk 2021-12-23T18:19:25Z https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot/m-p/1689193#M52600 <P>Hi Qlik Community,</P><P>I have attached an image which shows the problem and required result Excel. The measure is the count of contribution which is calculated as count(contribution). I have 2 questions:</P><P>1. I need to present it in the form of a pivot as shown in the image with the heading "Query".</P><P>2. Once the first problem is solved, I need to show row-wise sum as shown in the image with the heading "Required Result".</P><P>Please note that values highlighted in yellow are to be excluded.</P><P>I would really appreciate the help. Thanks</P><P>&nbsp;Kashif</P> Thu, 23 Dec 2021 18:19:25 GMT https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot/m-p/1689193#M52600 kash04kk 2021-12-23T18:19:25Z