Excel Tips - GETPIVOTDATA

 Pivot tables in Excel are a great way to begin to analyse your data

Using the GETPIVOTDATA function you can extract specific points in the data and return them to a single cell  

Think of it as a lookup directly onto a pivot table 

This short guide shows you how it works with an example 

The ability to return a single value from a pivot table can be a really powerful way to add flexibility to your excel reporting, by editing the GETPIVOTDATA formula you can return the values for the interesect of up to 126 dimensions