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
Bookmarks