How do I get the percentage to work by group

		Microsoft Office Forums > Microsoft Excel > Excel
How do I get the percentage to work by group

FAQ

Thread Tools

Display Modes

08-31-2020, 11:20 AM

wheddingsjr wheddingsjr is offline

Windows 7 64bit How do I get the percentage to work by group

Office 2016

Advanced Beginner

Join Date: Mar 2017

Posts: 76

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

Book3.xlsx (14.2 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Percentage of . . .	chaserwill	Excel	1	03-10-2017 09:28 AM
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
overall percentage	ketanco	Project	1	08-04-2012 05:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 PM.