Aggregation in pivot table

[Femke_DPG]

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

[brunobertels]

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