MWhiteDesigns
Well-known Member
- Joined
- Nov 17, 2010
- Messages
- 646
- Office Version
- 2016
- Platform
- Windows
I have a pivot table with 3 fields in the rows category. I accidentally cut off the first one in the picture, but it shows as "Day". I need the percent of total for each row for the 2nd field in the rows category. I've played around with the % of show values as setting but I cannot get what I need. See sample below.
I need the percentage to show for claim bucket but within each submit bucket. so the percentage for 0-1 hour would be 2262/4488, the 1-2 hours 265/4488, so on and so forth for the entire 730-11 bucket. Then the 11am-4pm bucket the same thing. 0-1 hour = 6415/11635 etc.
Is this possible? I can't for the life of me figure it out. I really don't want to have to copy and paste the tables, then manually insert formulas as I am going to have about 30 tables.
.
TYIA
I need the percentage to show for claim bucket but within each submit bucket. so the percentage for 0-1 hour would be 2262/4488, the 1-2 hours 265/4488, so on and so forth for the entire 730-11 bucket. Then the 11am-4pm bucket the same thing. 0-1 hour = 6415/11635 etc.
Is this possible? I can't for the life of me figure it out. I really don't want to have to copy and paste the tables, then manually insert formulas as I am going to have about 30 tables.
.
TYIA
Last edited: