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.
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.