topic Re: Subtotal for a Particular Pivot Dimension in QlikView https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482917#M180499 <HTML><HEAD></HEAD><BODY><P>Hi Tom, </P><P></P><P>Marcus is right but you can cheat QV using dimensionality() and colors</P><P></P><P>in background and text , test the dimension Area and the dimensionality() and play with text and background color</P><P></P><P>enjoy it</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 13 Dec 2013 15:42:50 GMT 2013-12-13T15:42:50Z Subtotal for a Particular Pivot Dimension https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482915#M180497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following Pivot (Table1) and I need to subtotal the 'Sub Indicator' dimension only where Area is = 'Two'.&nbsp; Can anyone help on the correct expression please?</P><P></P><P><IMG alt="sub_total_example.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50434_sub_total_example.png" /></P><P></P><P>Many thanks,</P><P></P><P>Tom</P></BODY></HTML> Fri, 13 Dec 2013 15:22:47 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482915#M180497 2013-12-13T15:22:47Z Re: Subtotal for a Particular Pivot Dimension https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482916#M180498 <HTML><HEAD></HEAD><BODY><P>This isn't directly possible - sub-totals for any field yes or no. But you could create an additionally field-value 'Total' in 'Sub Indicator' and use an If-loop in your expression.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 13 Dec 2013 15:27:34 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482916#M180498 marcus_sommer 2013-12-13T15:27:34Z Re: Subtotal for a Particular Pivot Dimension https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482917#M180499 <HTML><HEAD></HEAD><BODY><P>Hi Tom, </P><P></P><P>Marcus is right but you can cheat QV using dimensionality() and colors</P><P></P><P>in background and text , test the dimension Area and the dimensionality() and play with text and background color</P><P></P><P>enjoy it</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 13 Dec 2013 15:42:50 GMT https://community.qlik.com/t5/QlikView/Subtotal-for-a-Particular-Pivot-Dimension/m-p/482917#M180499 2013-12-13T15:42:50Z