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

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #pivottables #percentages

[MikeThomas]

Do you want more videos about Pivot Tables? Let me know in the comments

[fluffyhoneytina]

how can you show growth instead of difference?