calculations within a pivot table

C

ceepee

I have a simple pivot table with just one column of data that is "gran
totalled" at the bottom. I need to insert a formula that will give m
a 2nd column of data which shows the first column as a % of the total.

E.g.

fixed 20 20%
can't be fixed 40 40%
to be fixed 30 30%
not tested 10 10%
Grand Total 100 100%

Any help would be much appreciated. Thank
 
M

mzehr

Hi Ceepee,
very simple . . when setting up the layout of your pivot
table, drag the Amount into the data section and set that
as a sum of Amount. Then drag the Amount into the data
section again, rename it, set is as a sum of Amount, then
select the options button on the Pivot Table Field form,
and under "show data as" field, select % of total.

HTH
 
Top