5 Replies Latest reply: Sep 28, 2012 10:26 AM by David_T RSS

    PIVOT Table Sub-totals

    954356
      Hello Answers Gurus

      I have a simple question on calculating sub-totals in a PIVOT table. Here is my requirement -

      01 Expenses Item1 $25.00
      Item2 $35.00

      02 Revenue Item1 $10.00
      Item2 $15.00
      Item3 $37.00

      03 Goods Item1 $12.00
      Item2 $11.00
      Item3 $45.00

      Need to calculate Sub totals for
      1) Expenses , Revenue and Goods - This is simple, I use the Calculate filed and I am able to find the Subtotals.
      2) Have to find Subtotals for Expenses Subtotal + Revenue Subtotal AND also Subtotals for Revenue Subtotal + Goods Subtotal..

      How can I achieve the 2 item ? Please advise

      Thanks,
      Sam