Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2016, 11:26 PM
tupham tupham is offline Show calculated fields within the Pivot Table Windows 7 64bit Show calculated fields within the Pivot Table Office 2010 64bit
Advanced Beginner
 
Join Date: Aug 2008
Posts: 57
tupham is on a distinguished road
Default

If you can be a bit flexible with the position of the percentages, try adding the field being counted (number of students) into the Values area of the pivot table. Field settings for the second instance of the field will be "sum" and Show Values As will be "% or Grand Total".
Good luck with it.
Reply With Quote
  #2  
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
Reply



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 10:33 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