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.
Links to the video and individual sections below:
Generate Percentages in Pivot Tables Containing Row & Column Values
Generate Percentages in Pivot Tables with Parent & Child Row Values
Difference and % Difference: What is it and how to calculate it
Running Total and % Running Total: What is it and how to calculate it