6 Replies Latest reply: Dec 28, 2013 11:32 AM by Manish Kachhia RSS

    Pivot Table add row with total

      I wish to perform simply the sum of field values for 3 columns of a pivot table chart. should look like this

       

      Portfolio  Rev11  Rev12  Rev13
      Port1      10       5         2
      Port2      10       10       10
      TOTAL    20       15       12

       

      i cannot figure out how to add this TOTAL row. I tried to add SUM(Rev11) in the expression tab, but this is adding a column and not a row. the values in this column are identical to values in the colmn Rev11.

       

      Do you have a link to reference or solution ?

       

      regards