Excel Pivot Tables Year on Year Change
PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent Excel versions is ‘Show Values As’. In Excel 2007 it was hidden 3 clicks away in the Value Field Settings dialog box (see below): Then in Excel 2010 it was given prime position in the …