topic Re: How to create row wise grand total in pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-row-wise-grand-total-in-pivot-table/m-p/733966#M262905 <HTML><HEAD></HEAD><BODY><P>In the screenshot below, enable 'partial sums' checkbox for both country and month. </P><P>You can also change 'label for totals' as well.</P><P></P><P><IMG alt="grandtotal.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63963_grandtotal.PNG.png" style="width: 620px; height: 412px;" /></P></BODY></HTML> Thu, 07 Aug 2014 16:42:48 GMT JonnyPoole 2014-08-07T16:42:48Z How to create row wise grand total in pivot table? https://community.qlik.com/t5/QlikView/How-to-create-row-wise-grand-total-in-pivot-table/m-p/733965#M262904 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD height="17" width="64">Country</TD><TD width="64">Jan</TD><TD width="64">feb</TD><TD width="64">mar</TD><TD width="64">apr</TD><TD class="xl63" width="64">Grandtotal</TD></TR><TR><TD height="17">a</TD><TD align="right">2</TD><TD align="right">4</TD><TD align="right">5</TD><TD align="right">2</TD><TD align="right" class="xl63">13</TD></TR><TR><TD height="17">b</TD><TD align="right">5</TD><TD align="right">1</TD><TD align="right">2</TD><TD align="right">4</TD><TD align="right" class="xl63">12</TD></TR><TR><TD height="17">c</TD><TD align="right">1</TD><TD align="right">2</TD><TD align="right">5</TD><TD align="right">3</TD><TD align="right" class="xl63">11</TD></TR><TR><TD height="17">Grand total</TD><TD align="right">8</TD><TD align="right">7</TD><TD align="right">12</TD><TD align="right">9</TD><TD align="right" class="xl63">36</TD></TR></TBODY></TABLE><P></P><P>How to create row wise grand total in pivot table?</P></BODY></HTML> Thu, 07 Aug 2014 16:09:15 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-wise-grand-total-in-pivot-table/m-p/733965#M262904 2014-08-07T16:09:15Z Re: How to create row wise grand total in pivot table? https://community.qlik.com/t5/QlikView/How-to-create-row-wise-grand-total-in-pivot-table/m-p/733966#M262905 <HTML><HEAD></HEAD><BODY><P>In the screenshot below, enable 'partial sums' checkbox for both country and month. </P><P>You can also change 'label for totals' as well.</P><P></P><P><IMG alt="grandtotal.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63963_grandtotal.PNG.png" style="width: 620px; height: 412px;" /></P></BODY></HTML> Thu, 07 Aug 2014 16:42:48 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-wise-grand-total-in-pivot-table/m-p/733966#M262905 JonnyPoole 2014-08-07T16:42:48Z