4 Replies Latest reply: May 12, 2014 4:03 AM by anbu cheliyan RSS

    How to add grand total for expression at the bottom of a pivot table

      Hi, how do I add a grand total row for each column in a pivot table? I want exactly like the one below. I have tried using the 'show partial sums' option but it does not create a row at the bottom to show total for each column but it creates another column beside each sector. Thanks!

      Shift

      Sector 1

      Sector 2

      Sector 3

      Day

      1

      2

      4

      Night

      2

      5

      2

      Day

      3

      3

      1

      Grand Total

      6

      10

      7