Aggregation in pivot table

Femke_DPG — Mon, 05 Dec 2022 11:50:42 GMT

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

Re: Aggregation in pivot table

brunobertels — Tue, 06 Dec 2022 08:52:18 GMT

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

topic Re: Aggregation in pivot table in App Development

Aggregation in pivot table

Re: Aggregation in pivot table