Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

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.


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.

This article is from the free online

How to Use Microsoft Excel for Data Analysis

Created by
FutureLearn - Learning For Life

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.

Start Learning now