Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,180
Default Excel 2007 - Pivot Table - field calculation help

Excel 2007
Plain vanilla Pivot Table
http://www.mediafire.com/file/2ydy3m...09_17_09a.xlsx
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I remove #DIV/0! in a pivot table calculation field ? fabre jerome Excel Discussion (Misc queries) 2 September 7th 09 02:36 PM
How do I insert the same field twice in an Excel 2007 pivot table burtgard Excel Worksheet Functions 1 February 14th 08 01:05 AM
calculation field in a Pivot Table Richard Excel Discussion (Misc queries) 0 December 11th 07 06:41 PM
Excel 2007 Pivot Table - Group Field function is not always availa JLW1 Excel Worksheet Functions 1 October 23rd 07 02:31 PM
Using Subtotal field of a pivot table in a calculation Ailish Excel Discussion (Misc queries) 2 February 23rd 07 01:03 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"