topic Re: Weekly Average in Percentage % in a Pivot in QlikView https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438994#M431972 <HTML><HEAD></HEAD><BODY><P>Thank you very much, Sunny. You are always helpful!</P></BODY></HTML> Wed, 20 Dec 2017 18:09:39 GMT chriys1337 2017-12-20T18:09:39Z Weekly Average in Percentage % in a Pivot https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438992#M431970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having some sales data where I am showing the Weekly Average Target&nbsp; for different Opportunity categories (MT,LT)&nbsp; and also would like to show the %-Split between the Weekly Average Targets.</P><P></P><P>Unfortunately I don't know how to do it, I am just able to show the %-Split between the Total Targets.</P><P></P><P>Can anybody please help me?</P></BODY></HTML> Wed, 20 Dec 2017 15:58:52 GMT https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438992#M431970 chriys1337 2017-12-20T15:58:52Z Re: Weekly Average in Percentage % in a Pivot https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438993#M431971 <HTML><HEAD></HEAD><BODY><P>This</P><P></P><P><STRONG>Sum(Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID)) /</STRONG></P><P><STRONG>Sum(TOTAL Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID)) </STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187750_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 20 Dec 2017 16:25:58 GMT https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438993#M431971 sunny_talwar 2017-12-20T16:25:58Z Re: Weekly Average in Percentage % in a Pivot https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438994#M431972 <HTML><HEAD></HEAD><BODY><P>Thank you very much, Sunny. You are always helpful!</P></BODY></HTML> Wed, 20 Dec 2017 18:09:39 GMT https://community.qlik.com/t5/QlikView/Weekly-Average-in-Percentage-in-a-Pivot/m-p/1438994#M431972 chriys1337 2017-12-20T18:09:39Z