Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

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

When Excel displays the empty PivotTable frame (Figure B), start dragging columns from the field list to the sections below: Filters, Columns, Rows, and Values.

Excel’s intuitive drag-and-drop interface allows you to easily arrange fields in the Rows, Columns, Values, and Filters areas, giving you complete control over how your data is structured.

It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.

Filter_array, which is optional, indicates which rows should be included or excluded from the output. Field_relationship, which is optional, specifies how relationships between fields are managed when ...

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