Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-01-2020, 07:10 AM
p45cal's Avatar
p45cal p45cal is offline How do I get the percentage to work by group Windows 10 How do I get the percentage to work by group Office 2019
Expert
 
Join Date: Apr 2014
Posts: 963
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Instead of show values as % of Grand Total, use either:
% of Parent Row total
which will show the colour subtotals as percent of Grand Total still,

or:
% of Parent total
and choose COLOR as the base field, which will show the subtotals as all 100%.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage of . . . chaserwill Excel 1 03-10-2017 09:28 AM
How do I get the percentage to work by group Need forumla for percentage mquillen Excel 5 02-06-2017 08:59 AM
Group records - multiple IF stmts - Text After Group baum12 Mail Merge 1 05-25-2015 12:57 AM
Group Table Rows/Column (like Excel Group) eoinymc Word 1 03-11-2014 04:51 AM
How do I get the percentage to work by group overall percentage ketanco Project 1 08-04-2012 05:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 PM.


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