add result column to pivot table

[kenw100]

I have 2 columns in a pivot table - decription and
amount. I need to calc a % of each value of the total.
I don't know how to do that.

 

[Debra Dalgleish]

Add another copy of the Amount field to the pivot table's data area.
To display, the fields horizontally, drag the Data button, onto the cell
that contains the word 'Total' -- there's a picture here:

http://www.contextures.com/xlPivot02.html

Right-click on the heading for the second Amount column
Choose Field Settings
Click the Options button
Type a Name for the field, e.g. Percent
Choose to 'Show Data as' % of column
Click OK