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

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