topic Re: custom subtotals in QlikView https://community.qlik.com/t5/QlikView/custom-subtotals/m-p/856841#M1017887 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Tue, 07 Apr 2015 12:07:33 GMT Gysbert_Wassenaar 2015-04-07T12:07:33Z custom subtotals https://community.qlik.com/t5/QlikView/custom-subtotals/m-p/856840#M1017886 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have got a problem statement where i need subtotal of first two rows as third row value.</P><P>I am using this table:</P><TABLE border="1" class="jiveBorder" height="151" style="border: 1px solid #000000; width: 341px; height: 138px;"><TBODY><TR><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>BRAND</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>PRODUCT</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>PRICE</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">90</TD></TR></TBODY></TABLE><P></P><P>and i need my pivot table as:</P><TABLE border="1" class="jiveBorder" height="201" style="border: 1px solid #000000;" width="333"><TBODY><TR><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>BRAND</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>PRODUCT</STRONG></TH><TH style="padding: 2px; text-align: center; color: #ffffff; background-color: #6690bc;" valign="middle"><STRONG>PRICE</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">SUBTOTAL</TD><TD style="padding: 2px;">60</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">SUBTOTAL</TD><TD style="padding: 2px;">120</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Stabdha</P></BODY></HTML> Mon, 06 Apr 2015 08:19:38 GMT https://community.qlik.com/t5/QlikView/custom-subtotals/m-p/856840#M1017886 Anonymous 2015-04-06T08:19:38Z Re: custom subtotals https://community.qlik.com/t5/QlikView/custom-subtotals/m-p/856841#M1017887 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Tue, 07 Apr 2015 12:07:33 GMT https://community.qlik.com/t5/QlikView/custom-subtotals/m-p/856841#M1017887 Gysbert_Wassenaar 2015-04-07T12:07:33Z