Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. -- Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif with Multiple Criteria | Excel Worksheet Functions | |||
Sumif multiple criteria? | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria | Excel Worksheet Functions | |||
SUMIF, multiple criteria | Excel Discussion (Misc queries) |