Hi Amanda

Right click on a cell in your PT. Select PT WizardLayout.
Double click on the relevant data field and select Options. As you
scroll down you will see there are options to express the value as % of
different things.
If you want both the absolute and the percentage, drag the filed to the
data area twice, setting 1 to Sum or Count as required, and the other to
the percentage option.

--
Regards

Roger Govier


"Amanda" wrote in message
...
Hi there

I need to get the % of totals in the pivot table and don't know the
formula
to use when using the Insert calculated field option in the pivot
table.

Can someone assist