topic problem with a pivot table and set analysis in Management & Governance

problem with a pivot table and set analysis

zied_ahmed1 — Tue, 02 May 2017 15:03:45 GMT

Hello I have a pivot table and i would like to display the average of Sum(Taux) but i have a wrong value :

for example in avr i must have a value near to 23,64% and in mai i need to have a value close to 100%

and this is the set analyses used for this

if(Dimensionality()=1, Avg(Aggr(Sum(Taux), Plaque_flotte)),sum(Taux))

Regards

sunny_talwar — Tue, 02 May 2017 15:14:41 GMT

Can you try this

Avg(Aggr(Sum(Taux), Plaque_flotte))

zied_ahmed1 — Tue, 02 May 2017 15:26:52 GMT

Hello Sunny,

this is the result of your set analysis there is no values in mai and the value in avr are wrong...

sunny_talwar — Tue, 02 May 2017 15:28:29 GMT

Would you be able to share a sample?

sunny_talwar — Tue, 02 May 2017 16:27:49 GMT

You have three dimensions in your chart

Avg(Aggr(Sum(Taux), Plaque_flotte, Dimension2, Dimension3))

I saw that your dimension3 (month) is a calculation... carry that out in the script and use that here

zied_ahmed1 — Tue, 02 May 2017 16:39:53 GMT

yes i do this but the average is still wrong ...

sunny_talwar — Tue, 02 May 2017 16:40:46 GMT

Did you take your third dimension to the script?

Month(Date) as Month? and use Month in the aggr() function