Excel Pivots - tips and tricks

Latest Articles

How to Clear the Pivot Table Filter Cache

We’ve just started a new financial year and all our source data has been cleared out ready to start afresh. I was expecting to refresh my standard pivot table reports to see refreshed and tidy tables that had clear pivot...

Using Pivot Tables to Compare Data

An easy and risk-free way to compare data from two or more sources is by using a pivot table. In this tutorial I will demonstrate why you should add pivot table comparisons to your data analysis toolbox and forget about...

Quick Tip to Sort Pivot Filters

I regularly use pivot filters with multiple items to select from and if these aren’t sorted alphabetically or numerically it is a nightmare task to find the items I’m interested in.

Amending Calculated Pivot Fields

If you can create a user-defined calculated field for your pivot table you really need to know how to amend those calculated pivot fields as well: