1 Reply Latest reply: Dec 18, 2016 5:59 PM by Lech Miszkiewicz RSS

    Average column in pivot table or Table

    Massimo Carucci

      I have a pivot table that shows expenses per month. How can I create a column that shows average expenses for the selected period?

       

      EXAMPLE PIVOT TABLE

           

      2016-Jan2016-Feb2016-MarTOTALSAVG
      Payee 1 200,00 € 150,00 € 350,00 € 175,00 €
      Payee 2 120,00 € 120,00 € 120,00 €
      Payee 3 400,00 € 300,00 € 700,00 € 350,00 €

       

       

      I tried with Aggr() function, but it not consider the months where the value is null



      Some advice?