Excel PivotTable - Show Percentages of Parent Totals and Grand Totals
21.8 هزار بار بازدید -
3 سال پیش
-
In Excel, if you have
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
drive.google.com/file/d/1YXX6HLEC7662Db5m4AD8_Jc3L…
Percentage of Parent Total screenshot
drive.google.com/file/d/1EXOjfqXu8JPPDbsJwwYG_7vZp…
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 – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – www.tubebuddy.com/chrismenard
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!
3 سال پیش
در تاریخ 1400/09/15 منتشر شده
است.
21,811
بـار بازدید شده