Pivot Table query

[jarl1947]

I have created a pivot table which totals incidents across a range of activities. I want to show each of the incidents as a % of the total in a column alongside the actual totals. I found a past tip which seemed to do just that.
The tip I used suggested dragging 2 versions of the field I which to total, right clicking the second and selecting the % of column option from the resulting dialogue box. WhenI tried it the %'s were displayed as separate rows underneath each of the numerical totals.

Can anyone suggest were I went wrong? Thanks.
I'm using Excel 2000.

 

[gingerafro]

The error that you are getting is probably because your pivot table is not called PivotTable1.

To find out its name, right click on your pivottable and select table options.

Change the macro to match and try it again.

 

[jarl1947]

Andrew/gingerafro, sorry for the delay in replying. Tried again on another worksheet and got it to work Thanks again for your help and patience. Much appreciated.