if you drag the Action field (not the count of action) in your pivot table
and drop it in the page field area (the area at the top of your pivot), it
should (remove) filter all the columns but the grand total.
you will have:
territory in the row label
count of action (summarized as % of column or % of total) in the value area
Action in the page field area

"Nightshade" wrote:

That did not seem to do anything

"Andrea" wrote:

try to drag and drop the column field (action) in the report field area

"Nightshade" wrote:

Thank you. That worked. I just have one more question. I still have the 3
detailed columns of percentages. If I try to hide them then grand total
percentage column is also hidden. Is there a way to not show the detailed
columns but just the grand total column?

"Andrea" wrote:

PS:if you are using excel 2003 you can add the ground total row from the
pivot option menu.

"Andrea" wrote:

add the grand total per row and you will have one column (the grand total per
row) showing you the percentage of the (total row y,n,m)/(total row+column
y,n,m) column

"Nightshade" wrote:

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.