Excel 2007 - Pivot Table - field calculation help

F

Franci

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top