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.

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.

In case you have more columns and you wish to have the % of the Gand total
(total of all rows and columns), you may use "% of total" instead.

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

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.

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.

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.

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.