View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franci Franci is offline
external usenet poster
 
Posts: 4
Default 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?