This discussion is archived
5 Replies Latest reply: Sep 28, 2012 10:26 AM by David_T RSS

PIVOT Table Sub-totals

954356 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points