topic Re: Pivot Table Total in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987669#M336749 <HTML><HEAD></HEAD><BODY><P>enable partial sums for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">BUSINESS_SOURCES in presentation tab</SPAN></P></BODY></HTML> Mon, 21 Sep 2015 04:53:40 GMT 2015-09-21T04:53:40Z Pivot Table Total https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987668#M336748 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have below pivot table in my QV document.</P><P></P><TABLE><TBODY><TR><TD></TD><TD>BUSINESS_TYPE</TD><TD>NEW_BUSI.</TD><TD>RENEWALS</TD><TD>Total</TD></TR><TR><TD>DEPT</TD><TD>BUSINESS_SOURCES</TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>CITY</TD><TD>FIN_INSTITUTE</TD><TD>7,886,294</TD><TD>11,967,726</TD><TD>19,854,020</TD></TR><TR><TD>CITY</TD><TD>BROKERS</TD><TD>2,528,363</TD><TD>3,429,568</TD><TD>5,957,931</TD></TR><TR><TD>CITY</TD><TD>BANKS</TD><TD>2,251,519</TD><TD>1,744,495</TD><TD>3,996,014</TD></TR><TR><TD>CITY</TD><TD>Total</TD><TD>12,666,176</TD><TD>17,141,789</TD><TD>29,807,965</TD></TR><TR><TD>HEAD</TD><TD>FIN_INSTITUTE</TD><TD>11,516,923</TD><TD>17,018,929</TD><TD>28,535,852</TD></TR><TR><TD>HEAD</TD><TD>BROKERS</TD><TD>2,262,000</TD><TD>6,244,468</TD><TD>8,506,469</TD></TR><TR><TD>HEAD</TD><TD>BANKS</TD><TD>1,084,472</TD><TD>444,017</TD><TD>1,528,489</TD></TR><TR><TD>HEAD</TD><TD>Total</TD><TD>14,863,395</TD><TD>23,707,414</TD><TD>38,570,809</TD></TR><TR><TD>REGION</TD><TD>FIN_INSTITUTE</TD><TD>8,218,136</TD><TD>7,109,669</TD><TD>15,327,806</TD></TR><TR><TD>REGION</TD><TD>BROKERS</TD><TD>1,392,852</TD><TD>2,537,745</TD><TD>3,930,597</TD></TR><TR><TD>REGION</TD><TD>BANKS</TD><TD>734,781</TD><TD>623,696</TD><TD>1,358,476</TD></TR><TR><TD>REGION</TD><TD>Total</TD><TD>10,345,769</TD><TD>10,271,110</TD><TD>20,616,878</TD></TR><TR><TD><SPAN style="color: #ff0000;">TOTAL</SPAN></TD><TD><SPAN style="color: #ff0000;">FIN_INSTITUTE</SPAN></TD><TD><SPAN style="color: #ff0000;">12,666,176</SPAN></TD><TD><SPAN style="color: #ff0000;">17,141,789</SPAN></TD><TD><SPAN style="color: #ff0000;">29,807,965</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">TOTAL</SPAN></TD><TD><SPAN style="color: #ff0000;">BROKERS</SPAN></TD><TD><SPAN style="color: #ff0000;">17,446,058</SPAN></TD><TD><SPAN style="color: #ff0000;">22,315,852</SPAN></TD><TD><SPAN style="color: #ff0000;">39,761,910</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">TOTAL</SPAN></TD><TD><SPAN style="color: #ff0000;">BANKS</SPAN></TD><TD><SPAN style="color: #ff0000;">26,434,619</SPAN></TD><TD><SPAN style="color: #ff0000;">35,905,212</SPAN></TD><TD><SPAN style="color: #ff0000;">62,339,831</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">TOTAL</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">26,445,099</SPAN></TD><TD><SPAN style="color: #ff0000;">40,405,186</SPAN></TD><TD><SPAN style="color: #ff0000;">66,850,286</SPAN></TD></TR></TBODY></TABLE><P></P><P>But I am unable obtain the total marked in red from the QV pivot table it self. Pls some one help me how to extract figures shown in red.</P></BODY></HTML> Mon, 21 Sep 2015 04:17:39 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987668#M336748 upaliwije 2015-09-21T04:17:39Z Re: Pivot Table Total https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987669#M336749 <HTML><HEAD></HEAD><BODY><P>enable partial sums for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">BUSINESS_SOURCES in presentation tab</SPAN></P></BODY></HTML> Mon, 21 Sep 2015 04:53:40 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987669#M336749 2015-09-21T04:53:40Z Re: Pivot Table Total https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987670#M336750 <HTML><HEAD></HEAD><BODY><P>I think options provided in below solution will help you to achieve something like you want - </P><P><A href="https://community.qlik.com/message/856332">Re: Sum and Count at the bottom of the same table.</A></P><P></P><P>Credited to&nbsp; <A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌, <A href="https://community.qlik.com/qlik-users/23109">jagan</A>‌</P></BODY></HTML> Mon, 21 Sep 2015 04:56:29 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987670#M336750 Digvijay_Singh 2015-09-21T04:56:29Z Re: Pivot Table Total https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987671#M336751 <HTML><HEAD></HEAD><BODY><P>Can some give me an idea of how to do what I want</P></BODY></HTML> Mon, 21 Sep 2015 15:46:22 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total/m-p/987671#M336751 upaliwije 2015-09-21T15:46:22Z