add result column to pivot table

K

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

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
 
Top