View Single Post
  #1   Report Post  
cdb
 
Posts: n/a
Default 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