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 ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]

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!

свернуть