topic Re: Total Value in Pivot Table. in QlikView https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753048#M268320 <HTML><HEAD></HEAD><BODY><P>step 1 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>dimension : DIMYEAR</P><P>expression :</P><P>Sum(</P><P>&nbsp; aggr(</P><P>&nbsp; round(</P><P>&nbsp; ((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))/</P><P>&nbsp; Count(DISTINCT [VIN No]))</P><P>&nbsp; )</P><P>&nbsp; ,DIMYEAR,Series)</P><P>)</P></BODY></HTML> Thu, 05 Feb 2015 15:37:01 GMT giakoum 2015-02-05T15:37:01Z Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753047#M268319 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Greetings for the day.</P><P></P><P>Please support with below requirement. Please find attachments for the requirement. I want to calculate the logic explained in QVW. Thanks in advance.</P></BODY></HTML> Thu, 05 Feb 2015 15:15:46 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753047#M268319 varunvarma 2015-02-05T15:15:46Z Re: Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753048#M268320 <HTML><HEAD></HEAD><BODY><P>step 1 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>dimension : DIMYEAR</P><P>expression :</P><P>Sum(</P><P>&nbsp; aggr(</P><P>&nbsp; round(</P><P>&nbsp; ((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))/</P><P>&nbsp; Count(DISTINCT [VIN No]))</P><P>&nbsp; )</P><P>&nbsp; ,DIMYEAR,Series)</P><P>)</P></BODY></HTML> Thu, 05 Feb 2015 15:37:01 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753048#M268320 giakoum 2015-02-05T15:37:01Z Re: Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753049#M268321 <HTML><HEAD></HEAD><BODY><P>See this:</P><P></P><P>= if(Dimensionality()&gt;0 or DIMYEAR=2006,<BR />sum(aggr(<BR />round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))<BR />/<BR />Count(DISTINCT [VIN No]))<BR />,DIMYEAR,Series))<BR />,<BR />sum(aggr(<BR />round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))<BR />/<BR />Count(DISTINCT [VIN No]))<BR />,DIMYEAR,Series))<BR />-<BR />before(sum(aggr(<BR />round((sum(aggr((DIMYEAR - SALEYEAR) * count(DISTINCT [VIN No]),DIMYEAR,SALEYEAR,Series)))<BR />/<BR />Count(DISTINCT [VIN No]))<BR />,DIMYEAR,Series)))<BR />)</P></BODY></HTML> Thu, 05 Feb 2015 15:50:03 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753049#M268321 Anonymous 2015-02-05T15:50:03Z Re: Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753050#M268322 <HTML><HEAD></HEAD><BODY><P>attached</P></BODY></HTML> Thu, 05 Feb 2015 15:54:03 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753050#M268322 Anonymous 2015-02-05T15:54:03Z Re: Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753051#M268323 <HTML><HEAD></HEAD><BODY><P>Thank you sir. I got it. </P></BODY></HTML> Thu, 05 Feb 2015 15:56:22 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753051#M268323 varunvarma 2015-02-05T15:56:22Z Re: Total Value in Pivot Table. https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753052#M268324 <HTML><HEAD></HEAD><BODY><P>Thank you sir</P></BODY></HTML> Thu, 05 Feb 2015 15:56:35 GMT https://community.qlik.com/t5/QlikView/Total-Value-in-Pivot-Table/m-p/753052#M268324 varunvarma 2015-02-05T15:56:35Z