topic RangeSum above can do that ? in QlikView https://community.qlik.com/t5/QlikView/RangeSum-above-can-do-that/m-p/1819250#M1213304 <P>Hi all,</P><P>I have a pivot table.</P><P>Current result:</P><TABLE><TBODY><TR><TD>Period</TD><TD>&nbsp;</TD><TD>202003</TD><TD>202004</TD><TD>202005</TD><TD>202006</TD><TD>202007</TD></TR><TR><TD>Expired membership - Main</TD><TD>　</TD><TD>86</TD><TD>52</TD><TD>47</TD><TD>57</TD><TD>57</TD></TR><TR><TD>Expired membership - Sub</TD><TD>　</TD><TD>2</TD><TD>55</TD><TD>48</TD><TD>59</TD><TD>57</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expect Result:</P><TABLE><TBODY><TR><TD>Period</TD><TD>&nbsp;</TD><TD>202003</TD><TD>202004</TD><TD>202005</TD></TR><TR><TD>Expired membership - Main</TD><TD>　</TD><TD>299</TD><TD>213</TD><TD>161</TD></TR><TR><TD>Expired membership - Sub</TD><TD>　</TD><TD>221</TD><TD>219</TD><TD>164</TD></TR></TBODY></TABLE><P>Example</P><P>column 202003, = 86+52+47+57+57</P><P>column 202004, =&nbsp;52+47+57+57</P><P>I am no idea how to do that</P><P>2 Dimensions:</P><P>=if(ITEM='MainExp','Expired membership - Main',if(ITEM='SubExp','Expired membership - Sub')) (Label: Period)</P><P>MthYear</P><P>Expressions:</P><P>RangeSum(Above(count(ITEM), 0, columnno(TOTAL)))</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 02 Jul 2021 04:30:50 GMT Chuayuko 2021-07-02T04:30:50Z RangeSum above can do that ? https://community.qlik.com/t5/QlikView/RangeSum-above-can-do-that/m-p/1819250#M1213304 <P>Hi all,</P><P>I have a pivot table.</P><P>Current result:</P><TABLE><TBODY><TR><TD>Period</TD><TD>&nbsp;</TD><TD>202003</TD><TD>202004</TD><TD>202005</TD><TD>202006</TD><TD>202007</TD></TR><TR><TD>Expired membership - Main</TD><TD>　</TD><TD>86</TD><TD>52</TD><TD>47</TD><TD>57</TD><TD>57</TD></TR><TR><TD>Expired membership - Sub</TD><TD>　</TD><TD>2</TD><TD>55</TD><TD>48</TD><TD>59</TD><TD>57</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expect Result:</P><TABLE><TBODY><TR><TD>Period</TD><TD>&nbsp;</TD><TD>202003</TD><TD>202004</TD><TD>202005</TD></TR><TR><TD>Expired membership - Main</TD><TD>　</TD><TD>299</TD><TD>213</TD><TD>161</TD></TR><TR><TD>Expired membership - Sub</TD><TD>　</TD><TD>221</TD><TD>219</TD><TD>164</TD></TR></TBODY></TABLE><P>Example</P><P>column 202003, = 86+52+47+57+57</P><P>column 202004, =&nbsp;52+47+57+57</P><P>I am no idea how to do that</P><P>2 Dimensions:</P><P>=if(ITEM='MainExp','Expired membership - Main',if(ITEM='SubExp','Expired membership - Sub')) (Label: Period)</P><P>MthYear</P><P>Expressions:</P><P>RangeSum(Above(count(ITEM), 0, columnno(TOTAL)))</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 02 Jul 2021 04:30:50 GMT https://community.qlik.com/t5/QlikView/RangeSum-above-can-do-that/m-p/1819250#M1213304 Chuayuko 2021-07-02T04:30:50Z