The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Further, be aware that as a default, Excel’s PivotTable sort function sorts by custom lists, which explains why a PivotTable will sort months (January, February, March, etc.) in month order instead of ...

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.

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

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...