Adding formula to PivotTable

[Guest]

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 FORMULA>Calculated 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

 

[Bernie Deitrick]

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