Weekly Average in Percentage % in a Pivot

[chriys1337]

Hi,

I am having some sales data where I am showing the Weekly Average Target  for different Opportunity categories (MT,LT)  and also would like to show the %-Split between the Weekly Average Targets.

Unfortunately I don't know how to do it, I am just able to show the %-Split between the Total Targets.

Can anybody please help me?

[sunny_talwar · Accepted solution]

This

Sum(Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID)) /

Sum(TOTAL Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID))

[chriys1337]

Thank you very much, Sunny. You are always helpful!