topic Re: Running Totals in two calculated dimensional table in QlikView https://community.qlik.com/t5/QlikView/Running-Totals-in-two-calculated-dimensional-table/m-p/1373157#M419418 <HTML><HEAD></HEAD><BODY><P>Hi, have you tried?:</P><P>RangeSum(Before(<STRONG>TOTAL</STRONG> sum(Sales),1, ColumnNo(TOTAL)-1))</P><P></P><P>If the same week has to be counted on running totals:</P><P><SPAN style="font-size: 13.3333px;">RangeSum(Before(</SPAN><STRONG style="font-size: 13.3333px;">TOTAL</STRONG><SPAN style="font-size: 13.3333px;"> sum(Sales),<STRONG>0</STRONG></SPAN><SPAN style="font-size: 13.3333px;">, ColumnNo(TOTAL)))</SPAN></P></BODY></HTML> Sun, 26 Nov 2017 19:37:22 GMT rubenmarin 2017-11-26T19:37:22Z Running Totals in two calculated dimensional table https://community.qlik.com/t5/QlikView/Running-Totals-in-two-calculated-dimensional-table/m-p/1373156#M419417 <HTML><HEAD></HEAD><BODY><P>Colleagues, good day!</P><P>Need your consult for the next issue:</P><P></P><P>I've one simple table with Dates and Sales.</P><P></P><P>In front-end i've pivot table, which have two calculated dimensions -&gt; to show sales by every weekend&nbsp; (include all dates for corresponded week) and monthend (<SPAN style="font-size: 13.3333px;">include all dates for corresponded month</SPAN>).</P><P></P><P>Task - calculate running totals sum. (using only set analysis and don't change position of dimensions)</P><P>Standard expression like RangeSum(Before(sum(Sales),1, ColumnNo(Total)-1)) doesn't work.</P><P></P><P>Will be glad for any idea how to solve this.</P><P>Necessary result&nbsp; is in attached excel.</P></BODY></HTML> Sun, 26 Nov 2017 12:35:04 GMT https://community.qlik.com/t5/QlikView/Running-Totals-in-two-calculated-dimensional-table/m-p/1373156#M419417 Anonymous 2017-11-26T12:35:04Z Re: Running Totals in two calculated dimensional table https://community.qlik.com/t5/QlikView/Running-Totals-in-two-calculated-dimensional-table/m-p/1373157#M419418 <HTML><HEAD></HEAD><BODY><P>Hi, have you tried?:</P><P>RangeSum(Before(<STRONG>TOTAL</STRONG> sum(Sales),1, ColumnNo(TOTAL)-1))</P><P></P><P>If the same week has to be counted on running totals:</P><P><SPAN style="font-size: 13.3333px;">RangeSum(Before(</SPAN><STRONG style="font-size: 13.3333px;">TOTAL</STRONG><SPAN style="font-size: 13.3333px;"> sum(Sales),<STRONG>0</STRONG></SPAN><SPAN style="font-size: 13.3333px;">, ColumnNo(TOTAL)))</SPAN></P></BODY></HTML> Sun, 26 Nov 2017 19:37:22 GMT https://community.qlik.com/t5/QlikView/Running-Totals-in-two-calculated-dimensional-table/m-p/1373157#M419418 rubenmarin 2017-11-26T19:37:22Z