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.