2 Replies Latest reply: Dec 27, 2010 8:58 AM by Logesh Jayaraman RSS

    Pivot subtotal

    Logesh Jayaraman

      Hi,

      In Pivot table how to get the row based sub totals.

       

        • Pivot subtotal
          Muzammil Syed

          Hi,

          Just add another Expression Which has the expression as Column(1)+Column(2).... .This will give you the Sum of that Row.

            • Pivot subtotal
              Logesh Jayaraman

              Thanks Syed,

              In the pivot table you have the option of converting the dimension(Rows ) in to columns. Also we have options to display the subtotals at the top or bottom of the chart. I was looking for the similar option. if the user is trying to change the rows in to columns at runtime he may looking for the totals to be displayed at the each row level .Instead of creating the expression.