Thread: [Solved] How do I get the percentage to work by group
View Single Post
 
Old 09-01-2020, 07:10 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
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