How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

Here’s some interesting (and borderline buggy) Excel PivotTable behaviour I learned about today from Charles-Henri Sauget, as well as the workaround for it courtesy of the great Greg Galloway. Say you ...