0 of 135 lessons complete (0%)
Pivot Tables

Enhancing the values e.g. percentage of another column

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Although most people can do a simple SUM or COUNT in a Pivot Table, for some reason they haven’t realised that you can also do a whole lot more. In fact most of the calculations you do outside the pivot table area (% of the total, cumulative values, growth from one period to the next) can all be done inside the Pivot Table.

This lesson covers the various ways to enhance the values in a Pivot Table e.g. percentage of another column, running total in the columns, difference from the previous month and more.

To see the full course contents click here.