topic Re: Pivot Table Sub-Totals in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Totals/m-p/983435#M525995 <HTML><HEAD></HEAD><BODY><P>You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by <A href="https://community.qlik.com/qlik-users/156808">Robert_Mika</A>‌</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P><P><A href="https://community.qlik.com/docs/DOC-8006">The second dimension... or how to use secondarydimensionality()</A></P></BODY></HTML> Wed, 09 Dec 2015 18:55:25 GMT sunny_talwar 2015-12-09T18:55:25Z Pivot Table Sub-Totals https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Totals/m-p/983434#M525994 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108502_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>- Above chart is a pivot table</P><P>- 2 dimensions (one vertical and other horizontal)</P><P>- 9 expressions (marked in GREEN)</P><P></P><P>Question:</P><P>1. I do not want subtotals for 2 expressions marked in RED at the bottom. Is it possible?</P><P>2.Also, can we have Subtotals - "Top" for one dimension and "bottom" for the other (Option available in presentation tab) ?</P></BODY></HTML> Wed, 09 Dec 2015 18:14:00 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Totals/m-p/983434#M525994 rishimessi19 2015-12-09T18:14:00Z Re: Pivot Table Sub-Totals https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Totals/m-p/983435#M525995 <HTML><HEAD></HEAD><BODY><P>You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by <A href="https://community.qlik.com/qlik-users/156808">Robert_Mika</A>‌</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P><P><A href="https://community.qlik.com/docs/DOC-8006">The second dimension... or how to use secondarydimensionality()</A></P></BODY></HTML> Wed, 09 Dec 2015 18:55:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Totals/m-p/983435#M525995 sunny_talwar 2015-12-09T18:55:25Z