Adding formula to PivotTable
I am brand new to creating and working with PivotTables. I have a budget for
each month. Across the top of each budget are HEADINGS, ie CATegory, DESCRIPTION, AMT PD, DEPOSITS, etc. I created the PivotTable to sum all like CAT together. I figured this part out. I also want to add a formula that tells me the percentage of each "summed" CAT when compared to the GRAND TOTAL of the PivotTable. I clicked on PivotTable on the toolbar and chose FORMULACalculated Field. The window that pops up shows NAME: Field1 FORMULA: =0 and list the headings that I have indicated above for each budget. How do I get it to figure the percentage. Thanks, Les |
Adding formula to PivotTable
Les,
Don't use a formula - drag another CAT onto the data field, set it to SUM, and then use the Field Settings / Options... Under "Show data as:" select "% of column" HTH, Bernie MS Excel MVP "WLMPilot" wrote in message ... I am brand new to creating and working with PivotTables. I have a budget for each month. Across the top of each budget are HEADINGS, ie CATegory, DESCRIPTION, AMT PD, DEPOSITS, etc. I created the PivotTable to sum all like CAT together. I figured this part out. I also want to add a formula that tells me the percentage of each "summed" CAT when compared to the GRAND TOTAL of the PivotTable. I clicked on PivotTable on the toolbar and chose FORMULACalculated Field. The window that pops up shows NAME: Field1 FORMULA: =0 and list the headings that I have indicated above for each budget. How do I get it to figure the percentage. Thanks, Les |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com