![]() |
|
#3
|
|||
|
|||
|
Thanks for your response. For some reason, the subtotals do not calculate properly. I am trying to get percentages of a particular column value. That means the numerator and denominator are in the same column of data. The "Show values as" functionality calculates the percentages for each row total even when I select "% Of" and specify the field. The dialog box wants me to specify a base, which I don't understand.
So, for example, here is what columns look like: Jan Feb Signed up 10 12 Attended 8 9 Cancelled 1 1 Missed 1 2 What I want to see are the following ratios: % attended 80% 75% % cancelled 10% 8% % missed 10% 17% For some reason, the formula returns the percentage of the row: % attended 47% 53% % cancelled 50% 50% % missed 33% 67% |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How do I get column titles to show up in my pivot table?
|
nrcahill | Excel | 3 | 03-07-2016 09:35 AM |
| Show percentage of results in a Pivot table | rogelinepaula | Excel | 0 | 11-22-2015 06:58 PM |
| Pivot Table:delete zero values when using calculated objects | Serge 007 | Excel | 1 | 06-05-2013 11:47 AM |
| Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
Pivot Table's fields
|
janis129 | Excel | 7 | 03-02-2010 03:16 PM |