Thread: [Solved] How do I get the percentage to work by group
View Single Post
 
Old 08-31-2020, 11:20 AM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
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