14 Replies Latest reply: Jan 17, 2014 4:08 AM by Shruti Kulkarni RSS

    Total in a column of pivot table

      I'm trying to get the sum of all the values of a table in a column but i'm can't get them.

      This is my table (and some of my tries...):

       

       

      Mes and Lab are the dimensions.

      What I want, is to get the TOTAL, but in a column.

      I was able to get it with the Aggr(Sum(Ventas), Mes), but it only appear in the first row.

      Basically, the real thing I want is just to have a column, with the value / total value of that column .

       

      Thanks in advance.