T
TamIam
Thank you in advance whoever can help me with this problem. I am using a
Pivot Table that looks like this:
DEPT [10000] - (Page)
Data
Type Account Description Period Sept Oct Nov
Revenue 75500 Cash LY 2007 1,000 1,500 0
FY 2008
500 0 1,000
Budget '08
1,500 1,500 1,500
Depending on the dept selected, I need to add the Revenue by Period by Month
and add the Expenses (below Revenue in Pivot Table) by Period by Month and
then simply show the surplus/deficit at the bottom.
I have been racking my brains with this one as for some reason the pivot
table report will not allow me to subtotal by period.
Huge thanks!!
Tammy.
Pivot Table that looks like this:
DEPT [10000] - (Page)
Data
Type Account Description Period Sept Oct Nov
Revenue 75500 Cash LY 2007 1,000 1,500 0
FY 2008
500 0 1,000
Budget '08
1,500 1,500 1,500
Depending on the dept selected, I need to add the Revenue by Period by Month
and add the Expenses (below Revenue in Pivot Table) by Period by Month and
then simply show the surplus/deficit at the bottom.
I have been racking my brains with this one as for some reason the pivot
table report will not allow me to subtotal by period.
Huge thanks!!
Tammy.