problem with a pivot table and set analysis

[zied_ahmed1]

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]

Can you try this

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

[zied_ahmed1]

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]

Would you be able to share a sample?

[sunny_talwar]

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]

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

[sunny_talwar]

Did you take your third dimension to the script?

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