W
WLMPilot
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
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