topic Re: accmulation in multidimensional pivot table in QlikView https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384479#M572239 <HTML><HEAD></HEAD><BODY><P>use this expression for accumulation:</P><P>=aggr(rangesum(above(sum(Revenue), 0, rowno())), _Date)</P></BODY></HTML> Wed, 05 Sep 2012 16:16:19 GMT whiteline 2012-09-05T16:16:19Z accmulation in multidimensional pivot table https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384478#M572238 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to build a pivot table like the following one. I tried with RangeSum(Above...)) but it doesn't work.</P><P>Can somebody help me? Thanks</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 716px;"><TBODY><TR><TD class="xl65" height="20" width="69">FiscalYear</TD><TD class="xl66" style="border-left: none;" width="64">Month</TD><TD class="xl66" style="border-left: none;" width="64">Week</TD><TD class="xl67" style="border-left: none;" width="75">Date</TD><TD class="xl66" style="border-left: none;" width="64">Revenues</TD><TD class="xl71" style="border-left: none;" width="180">Year Accumulated Revenues</TD><TD class="xl71" style="border-left: none;" width="200">Month Accumulated Revenues</TD></TR><TR><TD class="xl70" height="1220" rowspan="61" style="border-top: none;">2012</TD><TD class="xl70" rowspan="30" style="border-top: none;">Jun</TD><TD class="xl70" rowspan="3" style="border-top: none;">1</TD><TD class="xl68" style="border-top: none; border-left: none;">01/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">02/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">21</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">03/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">33</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">33</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">2</TD><TD class="xl68" style="border-top: none; border-left: none;">04/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">13</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">46</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">05/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">60</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">06/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">75</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">75</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">07/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">16</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">91</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">91</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">08/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">17</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">108</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">108</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">09/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">18</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">126</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">126</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">10/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">19</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">145</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">145</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">3</TD><TD class="xl68" style="border-top: none; border-left: none;">11/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">165</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">165</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">12/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">186</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">186</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">13/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">22</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">208</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">208</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">14/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">23</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">231</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">231</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">15/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">24</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">255</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">255</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">16/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">25</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">280</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">280</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">17/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">26</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">306</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">306</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">18/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">27</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">333</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">333</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">19/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">361</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">361</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">20/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">29</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">390</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">390</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">21/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">420</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">420</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">22/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">31</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">451</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">451</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">23/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">32</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">483</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">483</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">24/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">33</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">516</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">516</TD></TR><TR><TD class="xl70" height="120" rowspan="6" style="border-top: none;">5</TD><TD class="xl68" style="border-top: none; border-left: none;">25/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">34</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">550</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">550</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">26/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">35</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">585</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">585</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">27/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">36</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">621</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">621</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">28/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">37</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">658</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">658</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">29/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">38</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">696</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">696</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">30/06/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">39</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">735</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">735</TD></TR><TR><TD class="xl70" height="620" rowspan="31" style="border-top: none;">Jul</TD><TD class="xl70" style="border-top: none; border-left: none;">5</TD><TD class="xl68" style="border-top: none; border-left: none;">01/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">40</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">775</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">40</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">6</TD><TD class="xl68" style="border-top: none; border-left: none;">02/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">41</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">816</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">81</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">03/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">42</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">858</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">123</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">04/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">43</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">901</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">166</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">05/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">44</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">945</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">210</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">06/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">45</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">990</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">255</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">07/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1036</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">301</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">08/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">47</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1083</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">348</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">7</TD><TD class="xl68" style="border-top: none; border-left: none;">09/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">48</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1131</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">396</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">10/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">49</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1180</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">445</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">11/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1230</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">495</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">12/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">51</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1281</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">546</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">13/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">52</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1333</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">598</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">14/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">53</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1386</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">651</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">15/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">54</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1440</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">705</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">8</TD><TD class="xl68" style="border-top: none; border-left: none;">16/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">55</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1495</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">760</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">17/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">56</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1551</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">816</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">18/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">57</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1608</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">873</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">19/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">58</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1666</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">931</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">20/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">59</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1725</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">990</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">21/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">60</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1785</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1050</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">22/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">61</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1846</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1111</TD></TR><TR><TD class="xl70" height="140" rowspan="7" style="border-top: none;">9</TD><TD class="xl68" style="border-top: none; border-left: none;">23/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">62</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1908</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1173</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">24/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">63</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1971</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1236</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">25/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">64</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2035</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1300</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">26/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">65</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2100</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1365</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">27/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">66</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2166</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1431</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">28/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">67</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2233</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1498</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">29/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">68</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2301</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1566</TD></TR><TR><TD class="xl70" height="40" rowspan="2" style="border-top: none;">10</TD><TD class="xl68" style="border-top: none; border-left: none;">30/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">69</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2370</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1635</TD></TR><TR><TD class="xl68" height="20" style="border-top: none; border-left: none;">31/07/2012</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">70</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2440</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1705</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 05 Sep 2012 16:02:44 GMT https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384478#M572238 cmatcovich 2012-09-05T16:02:44Z Re: accmulation in multidimensional pivot table https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384479#M572239 <HTML><HEAD></HEAD><BODY><P>use this expression for accumulation:</P><P>=aggr(rangesum(above(sum(Revenue), 0, rowno())), _Date)</P></BODY></HTML> Wed, 05 Sep 2012 16:16:19 GMT https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384479#M572239 whiteline 2012-09-05T16:16:19Z Re: accmulation in multidimensional pivot table https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384480#M572240 <HTML><HEAD></HEAD><BODY><P>It works!!!!</P><P>I need to study deeply how "aggr" function works.</P><P>Thanks a lot!</P><P></P><P>Corrado</P></BODY></HTML> Fri, 07 Sep 2012 16:28:18 GMT https://community.qlik.com/t5/QlikView/accmulation-in-multidimensional-pivot-table/m-p/384480#M572240 cmatcovich 2012-09-07T16:28:18Z