7 Replies Latest reply: May 9, 2017 9:33 AM by Zied Ahmed RSS

    Average of Sum

    Zied Ahmed

      Hello,

      I have this pivot table and i would like to display the average of the sum of all Months :

       

      error.PNG

      this is the expression used :

      if (Dimensionality()=1, Avg(Aggr( Count({<[Year of date]={"$(=max([Year of date]))"}>}Num_Dossier)

      /

      Count({<[Year of date]={"$(=max([Year of date]))">}distinct (Plaque)), Plaque,[Month of date] ,[Year of date])),

       

       

      Count({<[Year of date]={"$(=max([Year of date]))"},>}Num_Dossier)

      /

      Count({<[Year of date]={"$(=max([Year of date]))"}>}distinct (Plaque)))

       

      He display the value of janv and not the avg

      Regards