topic pivot table dimensions sub total in QlikView https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413374#M153794 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P></P><P></P><P></P><P>dimensions:</P><P></P><P>=aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI)</P><P></P><P>dimensions subtotal&nbsp; does not appear.</P><P></P><P>Expressions sub-total ok </P><P></P><P></P><P>added sample</P></BODY></HTML> Tue, 02 Apr 2013 11:59:48 GMT selcukcadir 2013-04-02T11:59:48Z pivot table dimensions sub total https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413374#M153794 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P></P><P></P><P></P><P>dimensions:</P><P></P><P>=aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI)</P><P></P><P>dimensions subtotal&nbsp; does not appear.</P><P></P><P>Expressions sub-total ok </P><P></P><P></P><P>added sample</P></BODY></HTML> Tue, 02 Apr 2013 11:59:48 GMT https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413374#M153794 selcukcadir 2013-04-02T11:59:48Z Re: pivot table dimensions sub total https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413375#M153795 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; Try this.</P><P></P><P>&nbsp;&nbsp; =sum(aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI))</P><P></P><P>Regards,</P><P>Kaushik Solanki</P><P></P><P></P></BODY></HTML> Tue, 02 Apr 2013 12:02:19 GMT https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413375#M153795 kaushiknsolanki 2013-04-02T12:02:19Z Re: pivot table dimensions sub total https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413376#M153796 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">&nbsp;&nbsp; =sum(aggr(Sum (money(BTC_USD_2012,'##.##0 $')),SATICI,MUSTERI_ADI,ULKE_TANIMI))</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">error.</SPAN></P><P></P><P><SPAN style="color: #737373; background-color: #ffffff; font-family: Arial;">dimensions <STRONG>subtotal</STRONG>&nbsp; does not appear.&nbsp;&nbsp;&nbsp; (empty)</SPAN></P><P><SPAN style="color: #737373; background-color: #ffffff; font-family: Arial;"><BR /></SPAN></P><P>How to get subtotal ?&nbsp; image (False)&nbsp;&nbsp; empty</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><IMG __jive_id="35922" class="jive-image-thumbnail jive-image" onclick="" alt="sample2.jpg" src="https://community.qlik.com/legacyfs/online/35922_sample2.jpg" width="450" /><BR /></SPAN></P></BODY></HTML> Tue, 02 Apr 2013 12:11:03 GMT https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413376#M153796 selcukcadir 2013-04-02T12:11:03Z Re: pivot table dimensions sub total https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413377#M153797 <HTML><HEAD></HEAD><BODY><P>So how can I find a solution. thanks.</P></BODY></HTML> Tue, 02 Apr 2013 13:58:05 GMT https://community.qlik.com/t5/QlikView/pivot-table-dimensions-sub-total/m-p/413377#M153797 selcukcadir 2013-04-02T13:58:05Z