topic How to create row and column total in a pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374091#M139213 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>how can I generate the row and column totals in a pivot table like the one hereunder:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT2</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT3</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT6</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>TOTAL</STRONG></SPAN></TH></TR><TR><TD>COUNTRY1</TD><TD>100</TD><TD>45</TD><TD>64</TD><TD>77</TD><TD>12</TD><TD>8</TD><TD><BR /></TD></TR><TR><TD>COUNTRY2</TD><TD>44</TD><TD>11</TD><TD>12</TD><TD>89</TD><TD>75</TD><TD>63</TD><TD><BR /></TD></TR><TR><TD>COUNTRY3</TD><TD>32</TD><TD>45</TD><TD>78</TD><TD>19</TD><TD>22</TD><TD>23</TD><TD><BR /></TD></TR><TR><TD>COUNTRY4</TD><TD>21</TD><TD>76</TD><TD>76</TD><TD>18</TD><TD>76</TD><TD>45</TD><TD><BR /></TD></TR><TR><TD>COUNTRY5</TD><TD>76</TD><TD>78</TD><TD>90</TD><TD>27</TD><TD>90</TD><TD>54</TD><TD><BR /></TD></TR><TR><TD>COUNTRY6</TD><TD>12</TD><TD>99</TD><TD>1</TD><TD>32</TD><TD>91</TD><TD>11</TD><TD><BR /></TD></TR><TR><TD>TOTAL</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>I cannot find the correct way to do it....</P><P></P><P>Thanks</P><P></P><P>Francesco</P></BODY></HTML> Wed, 28 Mar 2012 14:30:59 GMT 2012-03-28T14:30:59Z How to create row and column total in a pivot table https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374091#M139213 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>how can I generate the row and column totals in a pivot table like the one hereunder:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT2</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT3</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT4</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT5</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT6</STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN><SPAN style="color: #ffffff;"><STRONG>TOTAL</STRONG></SPAN></TH></TR><TR><TD>COUNTRY1</TD><TD>100</TD><TD>45</TD><TD>64</TD><TD>77</TD><TD>12</TD><TD>8</TD><TD><BR /></TD></TR><TR><TD>COUNTRY2</TD><TD>44</TD><TD>11</TD><TD>12</TD><TD>89</TD><TD>75</TD><TD>63</TD><TD><BR /></TD></TR><TR><TD>COUNTRY3</TD><TD>32</TD><TD>45</TD><TD>78</TD><TD>19</TD><TD>22</TD><TD>23</TD><TD><BR /></TD></TR><TR><TD>COUNTRY4</TD><TD>21</TD><TD>76</TD><TD>76</TD><TD>18</TD><TD>76</TD><TD>45</TD><TD><BR /></TD></TR><TR><TD>COUNTRY5</TD><TD>76</TD><TD>78</TD><TD>90</TD><TD>27</TD><TD>90</TD><TD>54</TD><TD><BR /></TD></TR><TR><TD>COUNTRY6</TD><TD>12</TD><TD>99</TD><TD>1</TD><TD>32</TD><TD>91</TD><TD>11</TD><TD><BR /></TD></TR><TR><TD>TOTAL</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>I cannot find the correct way to do it....</P><P></P><P>Thanks</P><P></P><P>Francesco</P></BODY></HTML> Wed, 28 Mar 2012 14:30:59 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374091#M139213 2012-03-28T14:30:59Z Re: How to create row and column total in a pivot table https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374092#M139214 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Goto --&gt; Presentation tab--&gt;Check ---&gt; Show partial sum --&gt; Check --&gt; Subtotal on top or Subtotal on Bottom</P><P></P><P>Regards,</P><P>Iyyappan</P></BODY></HTML> Wed, 28 Mar 2012 14:35:16 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374092#M139214 v_iyyappan 2012-03-28T14:35:16Z How to create row and column total in a pivot table https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374093#M139215 <HTML><HEAD></HEAD><BODY><P>presentation&nbsp; check patial sum for two dimension</P><P></P><P>for first dimension-&gt; total on top and for </P><P>second -&gt; value on bottom</P><P></P><P>hope this helps</P></BODY></HTML> Wed, 28 Mar 2012 14:36:02 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-and-column-total-in-a-pivot-table/m-p/374093#M139215 SunilChauhan 2012-03-28T14:36:02Z