topic Pivot Table _ Total Price in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424768#M490088 <HTML><HEAD></HEAD><BODY><P>Hi my friends<IMG __jive_id="24972" class="jive-image" alt="Pivot.jpg" src="https://community.qlik.com/legacyfs/online/24972_Pivot.jpg" />.</P><P>i want to use this total price i another expression fo each group.</P><P>what can i do?</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 12 Nov 2012 12:09:06 GMT 2012-11-12T12:09:06Z Pivot Table _ Total Price https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424768#M490088 <HTML><HEAD></HEAD><BODY><P>Hi my friends<IMG __jive_id="24972" class="jive-image" alt="Pivot.jpg" src="https://community.qlik.com/legacyfs/online/24972_Pivot.jpg" />.</P><P>i want to use this total price i another expression fo each group.</P><P>what can i do?</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 12 Nov 2012 12:09:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424768#M490088 2012-11-12T12:09:06Z Re: Pivot Table _ Total Price https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424769#M490089 <HTML><HEAD></HEAD><BODY><P>Use aggr( sum(Budget), Costnumber) to get the totals of sum(Budget) per Costnumber</P></BODY></HTML> Mon, 12 Nov 2012 12:14:31 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424769#M490089 Gysbert_Wassenaar 2012-11-12T12:14:31Z Re: Pivot Table _ Total Price https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424770#M490090 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Use aggr()&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustNum</SPAN><SPAN style="font-size: 8pt;">))<BR /></SPAN></P><P></P></BODY></HTML> Mon, 12 Nov 2012 12:19:01 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Total-Price/m-p/424770#M490090 renjithpl 2012-11-12T12:19:01Z