Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2020, 11:20 AM
wheddingsjr wheddingsjr is offline How do I get the percentage to work by group Windows 7 64bit How do I get the percentage to work by group Office 2016
Advanced Beginner
How do I get the percentage to work by group
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default How do I get the percentage to work by group


Hi all

I have a pivot table with 4 groups of colors with size and amount. I want to get the percentage of each color by group. I tried to use the percent function but its only doing the grand total and not the sub-total of each group. Can anyone assist? I am attaching a sample for your review.

Thanks in advance
Attached Files
File Type: xlsx Book3.xlsx (14.2 KB, 8 views)
Reply With Quote
  #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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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
Reply

Thread Tools
Display Modes


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 01:01 PM.


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