topic Re: How to customize total column in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088185#M362143 <HTML><HEAD></HEAD><BODY><P>May be as attached:</P></BODY></HTML> Mon, 25 Apr 2016 16:20:58 GMT trdandamudi 2016-04-25T16:20:58Z How to customize total column in pivot table https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088181#M362139 <HTML><HEAD></HEAD><BODY><P>dear friends,</P><P>I have coulumn A, Column B,Coulmn C in a pivot chart. The default Total column of Pivot table takes A+B+C by default.</P><P>I want the default Total Coulmn of Pivot Table as Coulmn A+Column B.</P><P>Please help.</P><P>How to achieve this in qlikview?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 407px;"><TBODY><TR><TD class="xl63" height="21" width="137"> </TD><TD class="xl64" style="border-left: none;" width="58"> Total</TD><TD class="xl65" style="border-left: none;" width="74">Column A</TD><TD class="xl65" style="border-left: none;" width="73"><SPAN style="font-size: 13.3333px;">Column B </SPAN></TD><TD class="xl65" style="border-left: none;" width="65"><SPAN style="font-size: 13.3333px;">Column C </SPAN></TD></TR><TR><TD class="xl66" height="20" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl67" style="border-top: none;"> </TD></TR><TR><TD class="xl68" height="20" style="border-top: none;"> Orders</TD><TD align="right" class="xl69" style="border-top: none;">20</TD><TD class="xl70" style="border-top: none;"> 10</TD><TD class="xl70" style="border-top: none;"> 10</TD><TD align="right" class="xl69" style="border-top: none;">10</TD></TR><TR><TD class="xl68" height="20" style="border-top: none;">&nbsp; Forecast</TD><TD align="right" class="xl69" style="border-top: none;">40</TD><TD align="right" class="xl71" style="border-top: none;">20</TD><TD align="right" class="xl71" style="border-top: none;">20</TD><TD align="right" class="xl71" style="border-top: none;">20</TD></TR><TR><TD class="xl72" height="20" style="border-top: none;"> </TD><TD class="xl73" style="border-top: none;"> </TD><TD class="xl74" style="border-top: none;"> </TD><TD class="xl74" style="border-top: none;"> </TD><TD class="xl74" style="border-top: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 22 Apr 2016 14:08:11 GMT https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088181#M362139 2016-04-22T14:08:11Z Re: How to customize total column in pivot table https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088182#M362140 <HTML><HEAD></HEAD><BODY><P>Perhaps with expressions like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(SecondaryDimensionality()=0, sum({&lt;<STRONG><EM>MyDim</EM></STRONG>={'Column A', 'Column B'}&gt;} Orders) , sum(Orders))</P><P></P><P>Replace MyDim with the name of the field that contains the values <SPAN style="font-size: 13.3333px;">'Column A', 'Column B' and 'Column C'</SPAN></P></BODY></HTML> Fri, 22 Apr 2016 15:30:10 GMT https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088182#M362140 Gysbert_Wassenaar 2016-04-22T15:30:10Z Re: How to customize total column in pivot table https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088183#M362141 <HTML><HEAD></HEAD><BODY><P>Can u please provide a sample application?</P><P>When I applied this formula it is not working properly for me. Please help</P></BODY></HTML> Mon, 25 Apr 2016 02:19:40 GMT https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088183#M362141 2016-04-25T02:19:40Z Re: How to customize total column in pivot table https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088184#M362142 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Can u please provide a sample application?</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>No, I'm lazy. Can you?</P></BODY></HTML> Mon, 25 Apr 2016 15:41:10 GMT https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088184#M362142 Gysbert_Wassenaar 2016-04-25T15:41:10Z Re: How to customize total column in pivot table https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088185#M362143 <HTML><HEAD></HEAD><BODY><P>May be as attached:</P></BODY></HTML> Mon, 25 Apr 2016 16:20:58 GMT https://community.qlik.com/t5/QlikView/How-to-customize-total-column-in-pivot-table/m-p/1088185#M362143 trdandamudi 2016-04-25T16:20:58Z