Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-07-2016, 02:12 PM
John in DSM John in DSM is offline Show calculated fields within the Pivot Table Windows 7 32bit Show calculated fields within the Pivot Table Office 2010 32bit
Novice
Show calculated fields within the Pivot Table
 
Join Date: Aug 2016
Posts: 2
John in DSM is on a distinguished road
Default Subtotals do not calculate

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%
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Show calculated fields within the Pivot Table 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
Show calculated fields within the Pivot Table Pivot Table's fields janis129 Excel 7 03-02-2010 03:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft