Pivot Table percentages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 PivotTable>Formulas>Calculated Field
Type a name, e.g. PctDecline
Type a formula: =Decline/Accept
Click OK

Format the new field as Percent.
 
Works a treat.

Thanks a lot.

Debra Dalgleish said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table percentages 1
Pivot Table Calculated Field - Sum/count 1
Pivot Table 2
including zero values in a pivot table 2
Average of % in pivot table 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot table filter list - listing irrelevant subcategorys 1
Possible to create formula columns within Pivot Tables? 1

Back
Top