Search This Blog

Thursday, July 9, 2020

Calculate Differences From Values in a Pivot Table

A pivot table is a great tool to do analysis since it's useful for summing up or aggregating data. However it has some fancier custom calculations and one of these is to find the difference between values. A useful example is when you want to see how many items you sold in the different months between two years. This video will show a data set of cars sales between 2017 and the previous year to figure out the difference of monthly sales between the two years. You might think it maybe a calculation to calculate the difference between two pivot tables, but it's just one and just subtraction (or comparison) between two columns It's a short video to show you how to make a year over year comparison between data.

No comments:

Post a Comment