# Pivot Table percentages-give the total number of accepts

1. ## Pivot Table percentages-give the total number of accepts

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

2. ## re: Pivot Table percentages-give the total number of accepts

You could create a calculated field:

Select a cell in the pivot table
From the Pivot toolbar, choose PivotTable>Formulas>Calculated 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

3. ## re: Pivot Table percentages-give the total number of accepts

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 PivotTable>Formulas>Calculated 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
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1