ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2007 - Pivot Table - field calculation help (https://www.excelbanter.com/excel-worksheet-functions/243005-excel-2007-pivot-table-field-calculation-help.html)

Franci

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?

Herbert Seidenberg

Excel 2007 - Pivot Table - field calculation help
 
Excel 2007
Plain vanilla Pivot Table
http://www.mediafire.com/file/2ydy3m...09_17_09a.xlsx


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com