Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This
Sum(Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID)) /
Sum(TOTAL Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID))
This
Sum(Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID)) /
Sum(TOTAL Aggr(Sum(Target)/Count(DISTINCT YearWeek), OppID))
Thank you very much, Sunny. You are always helpful!