Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Pivot Table - field calculation help
My spreadsheet has columns for:
Month; Team; Area; Budget; Tangible Expense; Intangible Expense; Total Expenses The pivot table rows are, in order: Team; Area; Budget; Month. The columns are Tangible Expense, Intangible Expense, Running Total (by base Month) I want to show the balance remaining in the budget for each area. Can that be done within the pivot table? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Pivot Table - field calculation help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove #DIV/0! in a pivot table calculation field ? | Excel Discussion (Misc queries) | |||
How do I insert the same field twice in an Excel 2007 pivot table | Excel Worksheet Functions | |||
calculation field in a Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table - Group Field function is not always availa | Excel Worksheet Functions | |||
Using Subtotal field of a pivot table in a calculation | Excel Discussion (Misc queries) |