Pivot Table percentages
 

I have created a pivot table that is running off some data that looks like
this (simplified version):

Name Accept Decline
Joe 1 0
Mary 1 0
Fred 0 1

The pivot table then counts these columns to give the total number of
accepts and declines (on 2 seperate lines). Is there a way within the pivot
table to represent the declines as a percentage of the accepts?

I've tried using the % of Row and % of Column, but I can't find a way of
doing it as a percentage of a different column/row. I have also tried the %
of and selecting the Accept Column from the list given there, but this just
produces an N/A error.

Any help greatly appreciated.

cdb

You could create a calculated field:

Select a cell in the pivot table
From the Pivot toolbar, choose PivotTableFormulasCalculated Field
Type a name, e.g. PctDecline
Type a formula: =Decline/Accept
Click OK

Format the new field as Percent.


cdb wrote:
I have created a pivot table that is running off some data that looks like
this (simplified version):

Name Accept Decline
Joe 1 0
Mary 1 0
Fred 0 1

The pivot table then counts these columns to give the total number of
accepts and declines (on 2 seperate lines). Is there a way within the pivot
table to represent the declines as a percentage of the accepts?

I've tried using the % of Row and % of Column, but I can't find a way of
doing it as a percentage of a different column/row. I have also tried the %
of and selecting the Accept Column from the list given there, but this just
produces an N/A error.

Any help greatly appreciated.

cdb


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Works a treat.

Thanks a lot.

"Debra Dalgleish" wrote:

You could create a calculated field:

Select a cell in the pivot table
From the Pivot toolbar, choose PivotTableFormulasCalculated Field
Type a name, e.g. PctDecline
Type a formula: =Decline/Accept
Click OK

Format the new field as Percent.


cdb wrote:
I have created a pivot table that is running off some data that looks like
this (simplified version):

Name Accept Decline
Joe 1 0
Mary 1 0
Fred 0 1

The pivot table then counts these columns to give the total number of
accepts and declines (on 2 seperate lines). Is there a way within the pivot
table to represent the declines as a percentage of the accepts?

I've tried using the % of Row and % of Column, but I can't find a way of
doing it as a percentage of a different column/row. I have also tried the %
of and selecting the Accept Column from the list given there, but this just
produces an N/A error.

Any help greatly appreciated.

cdb


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html