6 Replies Latest reply: May 2, 2017 12:40 PM by Sunny Talwar

# problem with a pivot table and set analysis

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

• ###### Re: problem with a pivot table and set analysis

Can you try this

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

• ###### Re: problem with a pivot table and set analysis

Hello Sunny,

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

• ###### Re: problem with a pivot table and set analysis

Would you be able to share a sample?

• ###### Re: problem with a pivot table and set analysis

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

• ###### Re: problem with a pivot table and set analysis

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

• ###### Re: problem with a pivot table and set analysis

Did you take your third dimension to the script?

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