This seems to give me multiple columns of percentages. My pivot table is as
follows: Territory as rows (ex.1,2,3) Action as columns (ex.Yes, No, Maybe).
The data section is a count of the action per territory (ex. 3 Yes's for
Territory 1). When I follow your below instructions I get 3 columns of
percentages with the headings Yes, No and Maybe. I just want one column that
adds together all the Yes, No and Maybe's for Territory 1 and divides it by
the total Yes, No and Maybe's for all the territories. Did I do something
wrong?

"Andrea" wrote:

Drag and drop the value field you wish the percentage to the value area.
right click any item in the new column. select "value field setting". select
the "show values as " tab. from the show value as drop down list select "% of
column".
this should do the job

"Nightshade" wrote:

I wish to add a column into my pivot table that will take the total of the
current row and divide it by the total of all rows. In other words I want a
column that will show me the percentage of each row of information. I just
want the one column of percentages, and cannot seem to get that. Please help.