4 Replies Latest reply: Dec 16, 2016 8:02 AM by Sunny Talwar RSS

    Show "Totals" row wise

    swetha r

      I have a Pivor table with two dimensions : "Month1" and  "Month2".

      And one expression :Sum(Sales)

      "Month2" is pivoted :  i.e, it appears as Columns.

       

      Now I want to sum the values row-wise and display them in the last column.

       

      Enabling "Show Pratial Sums" option is not resulting in  correct values.

       

      Please find the below output that is required.

       

      JanFebMarTotal
      Jan25815
      Feb1025641
      Mar58518
      Apr34613