topic Accumulation rows in pivot tables in QlikView https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190342#M52890 <HTML><HEAD></HEAD><BODY><P>Pivot table acts differently than a strait table. Try the strait table, but you wont have the ability to expand/calaps columns.</P><P></P></BODY></HTML> Tue, 23 Mar 2010 17:27:46 GMT 2010-03-23T17:27:46Z Accumulation rows in pivot tables https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190341#M52889 <HTML><HEAD></HEAD><BODY><P>As the subject say, I need to have an accumulation row in a pivot table but the option it's disabled.</P><P>Is there any way??</P><P></P><P>Thxs in advance..</P></BODY></HTML> Tue, 23 Mar 2010 16:27:26 GMT https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190341#M52889 2010-03-23T16:27:26Z Accumulation rows in pivot tables https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190342#M52890 <HTML><HEAD></HEAD><BODY><P>Pivot table acts differently than a strait table. Try the strait table, but you wont have the ability to expand/calaps columns.</P><P></P></BODY></HTML> Tue, 23 Mar 2010 17:27:46 GMT https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190342#M52890 2010-03-23T17:27:46Z Accumulation rows in pivot tables https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190343#M52891 <HTML><HEAD></HEAD><BODY><P></P><P>Try with</P><P>Pivot table for example for sales:</P><P>Expression column 1: sum(sales)</P><P>Expression column 2: rangesum (column (1), above (total column(2)))</P><P>Bye</P><BR /><BR /></BODY></HTML> Tue, 23 Mar 2010 17:47:56 GMT https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190343#M52891 2010-03-23T17:47:56Z Accumulation rows in pivot tables https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190344#M52892 <HTML><HEAD></HEAD><BODY><P>Oh yes Stefania! You're right! thxs.. <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>I used: <B>rangesum(Num,above(Num,1,(rowno()-1)))</B></P></BODY></HTML> Tue, 23 Mar 2010 19:53:43 GMT https://community.qlik.com/t5/QlikView/Accumulation-rows-in-pivot-tables/m-p/190344#M52892 2010-03-23T19:53:43Z