Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I'm stuck with following:
The sum of Apr (and other months too) must be 100 % so 3-98 + 1 + 2 + 99 +100 must be 100 %.
The 31.24 % and 23.18 % is correct, but the total of position group must be 100 % (yellow)
My measure is this:
If((Dimensionality()) = 2,
sum({$<Preferred={'Voorkeur'},[Surcharges Codes2]={'VKP'}>}[Number of Insertions])/sum(total <Advertiser, Month> [Number of Insertions]),
sum({$<Preferred={'Voorkeur'},[Surcharges Codes2]={'VKP'}>}[Number of Insertions])/sum(total <Advertiser> [Number of Insertions]))
Can anyone help me please?
Thanks a lot!!
Femke
Hi
not tested but you may need to aggr your mesure and use the qualifier nodistinct somewhere in your mesure
here an example i use in one of my app :
RED MESURE
sum( Volume)/
sum(distinct aggr(nodistinct <Famille> sum( Volume) ,$(vDimPeriode1)))
GREEN MESURE :
sum( Volume)/
sum(distinct aggr(nodistinct sum( Volume) ,$(vDimPeriode1),Famille))
Hop it helps