View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default 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