Excel Video 299 introduces a powerful way to look at trends over time by using percentages in your Pivot Table. Instead of putting numbers in the values area of the Pivot Table, today we’ll replace the numbers with percentages to see how the mix of clinic locations has changed over time. We’ll start by looking at locations as a percentage of the overall total, as a percentage of the column, and as a percentage of the row. These percentages make it easy for us to see how a clinic has changed over time in relation to the other locations.
If you’re following along in Excel 2007, you’ll notice Microsoft added some additional features for Pivot Tables in Excel 2010 that make analyzing trends more powerful. Stay tuned. In the next couple of videos we’ll review some of those changes.
