Excel: Pivot Table Percentages - Every Menu Item Covered

It's easy to generate percentages in a pivot table in Excel. No formulas needed. Just right click and select Show Values As. But then you're faced with nine choices (5 on a Mac).

In this video I take you through every one of those nine items, explaining when to use each one and showing what value each one generates.

For full details see the timestamps below:

⏱ Timestamps
00:00:00 Introduction
00:01:20 % of Grand Total
00:02:05 % of Column Total
00:02:27 % of..
00:03:25 % of Row Total
00:05:16 Generate Percentages in Pivot Tables Containing Row & Column Values
00:09:28 Generate Percentages in Pivot Tables with Parent & Child Row Values
00:12:59 Difference and % Difference: What is it and how to calculate it
00:15:01 Running Total and % Running Total: What is it and how to calculate it

🗒 Notes and Resources
Download a copy of the files used in this video: https://share.getcloudapp.com/o0uXg40y

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel #pivottables #percentages