Comparing Year Over Year Values Using the Pivot Table
In the previous section, we experimented with calculated columns and conditional formatting as a way to analyse data and find anomalies in the data.
Although the Pivot is a useful and powerful tool, it does have some deficiencies. In this next step, you will discover some pivot table limitations and how these limitations can be overcome.
Comparisons
One limitation of pivot tables is the ability to view comparative data. It is not possible to use calculated columns in your pivot table to visualise your comparative data.
To get around this, you can create a column outside of your pivot table to reference data from your pivot table. This will result in the GETPIVOTDATA function.
The disadvantage of combining pivot data with non-pivot data is that you are unable to visualise the data in a chart.
Join the discussion
Why, in your opinion, is it so necessary for the growth of a business to compare year over year data?Use the discussion section below and let us know your thoughts. Try to respond to at least one other post and once you’re happy with your contribution, click the Mark as Complete button to check the step off, then you can move to the next step.
How to Use Microsoft Excel for Data Analysis
How to Use Microsoft Excel for Data Analysis
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
