https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897858#M74112 <P>Rangesum on mutiple dimesion</P> <P>input table:</P> <P>Load * Inline [<BR />Name, Country, Sales<BR />Pankaj, India, 100<BR />Vikas, SL, 12<BR />Raju, WJ, 10<BR />Sujit, JH, 45<BR />];<BR /><BR />Output:</P> <TABLE width="268"> <TBODY> <TR> <TD width="64">Name</TD> <TD width="64">Country</TD> <TD width="76">Sum(Sales)</TD> <TD width="64">Rangesum</TD> </TR> <TR> <TD>Pankaj</TD> <TD>India</TD> <TD>100</TD> <TD>100</TD> </TR> <TR> <TD>Vikas</TD> <TD>SL</TD> <TD>12</TD> <TD>112</TD> </TR> <TR> <TD>Raju</TD> <TD>WJ</TD> <TD>10</TD> <TD>122</TD> </TR> <TR> <TD>Sujit</TD> <TD>JH</TD> <TD>45</TD> <TD>167</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I am using Aggr(RangeSum(above(sum(Sales),0,RowNo())),Country,Name)</P> Sat, 26 Feb 2022 03:17:23 GMT passionate 2022-02-26T03:17:23Z https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897858#M74112 <P>Rangesum on mutiple dimesion</P> <P>input table:</P> <P>Load * Inline [<BR />Name, Country, Sales<BR />Pankaj, India, 100<BR />Vikas, SL, 12<BR />Raju, WJ, 10<BR />Sujit, JH, 45<BR />];<BR /><BR />Output:</P> <TABLE width="268"> <TBODY> <TR> <TD width="64">Name</TD> <TD width="64">Country</TD> <TD width="76">Sum(Sales)</TD> <TD width="64">Rangesum</TD> </TR> <TR> <TD>Pankaj</TD> <TD>India</TD> <TD>100</TD> <TD>100</TD> </TR> <TR> <TD>Vikas</TD> <TD>SL</TD> <TD>12</TD> <TD>112</TD> </TR> <TR> <TD>Raju</TD> <TD>WJ</TD> <TD>10</TD> <TD>122</TD> </TR> <TR> <TD>Sujit</TD> <TD>JH</TD> <TD>45</TD> <TD>167</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I am using Aggr(RangeSum(above(sum(Sales),0,RowNo())),Country,Name)</P> Sat, 26 Feb 2022 03:17:23 GMT https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897858#M74112 passionate 2022-02-26T03:17:23Z https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897860#M74113 <P>May be something like this -&nbsp;</P> <P>RangeSum(above(Total sum(Sales),0,RowNo(Total)))</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Digvijay_Singh_0-1645846197098.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73146i5EB127321E4CCDEF/image-size/medium?v=v2&amp;px=400" role="button" title="Digvijay_Singh_0-1645846197098.png" alt="Digvijay_Singh_0-1645846197098.png" /></span></P> <P>&nbsp;</P> Sat, 26 Feb 2022 03:30:34 GMT https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897860#M74113 Digvijay_Singh 2022-02-26T03:30:34Z https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897899#M74117 <P>Thank you Digvijay!<BR />Much appreciate your response</P> Sat, 26 Feb 2022 12:18:32 GMT https://community.qlik.com/t5/App-Development/Rangesum-on-mutiple-dimesion/m-p/1897899#M74117 passionate 2022-02-26T12:18:32Z