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

    problem with a pivot table and set analysis

    Zied Ahmed

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

      problem.PNG

      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