Excel PivotTable - Show Percentages of Parent Totals and Grand Totals

In Excel, if you have subtotals in a PivotTable and need to calculate the percentage of the subtotal, you can use the percentage of the Parent Total feature. In this video, I'll also calculate the Grand Total Percentage along with the Parent Total.

Percentage of Grand Total screenshot

Percentage of Parent Total screenshot

Chapters:
0:00 Intro
1:17 Check figures for PivotTable
2:00 Create PivotTable
3:29 Percentage of Grand Total
4:28 Percentage of Parent Total
6:02 Subscribe

#msexcel #microsoftexcel #chrismenardtraining #chrismenard #chrismenardexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[magicnm]

Great. Straight to the topic. Big thumbs up

[Robert_]

Good stuff! I use the same process at work for vacancy rates company wide, then by divisions and departments.

[ahmedabdulahimahamud]

It is simple tricky, thank you so much

[hestiaa]

This is great. What my issue is that I frequently deal with demographic data . Is it possible to take two columns, e.g. gender, add them together for a specific race/ ethnicity category and the create a column which shows what percentage of the grand total does the two added columns represent?

[gfrsaaaar]

Hi, I'm trying to use your idea but I need to create calculated field returning a, b, c or d letter depends on percentage. With your solution I cannot do it because there are only numbers to choose. Sorry, i'm new with that. Probably I missed something