Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |