Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Calculating Field/item
I have a spreadsheet that contains 12 budgets (for ea month). I have created
a pivot table that combines each category (per month) in one column and gives the total amount paid for that category in the adjacent column with a SUM of all the amounts at the bottom of that column. HINT: This amount should and does match the SUM() function within the actual budget. What I want to do is create another column that will give the % of each category when compared to the total expense (sum of all categories). I have played around with the different calculated fields / items, but cannot seem to get it to work. Thanks in advance, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Calculating Field/item
Why not just add a formula outside the table in an adjacent column.
Debra Dalgleish http://www.contextures.com/tiptech.html has a lot of information on Pivot Tables that may help if you don't want to do what I suggested. -- Regards, Tom Ogilvy "WLMPilot" wrote in message ... I have a spreadsheet that contains 12 budgets (for ea month). I have created a pivot table that combines each category (per month) in one column and gives the total amount paid for that category in the adjacent column with a SUM of all the amounts at the bottom of that column. HINT: This amount should and does match the SUM() function within the actual budget. What I want to do is create another column that will give the % of each category when compared to the total expense (sum of all categories). I have played around with the different calculated fields / items, but cannot seem to get it to work. Thanks in advance, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table calculated field or item | Excel Worksheet Functions | |||
pivot table calculated field or item | Excel Discussion (Misc queries) | |||
Need Help Using Calculated Field or Item in Pivot Table | Excel Worksheet Functions | |||
Overwrite field item name in a Pivot table | Excel Discussion (Misc queries) | |||
Delete item from Pivot Table field? | Charts and Charting in Excel |