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

This is a tough question. Whether you are using the Report Filter or the new Excel 2010 Slicer feature in a pivot table, there is really no good way to change the filter with a formula. Instead, you ...

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

Robert L. wins a copy of Excel Gurus Gone Wild for his question, “How can you change a pivot table filter using a formula?” This is a tough question. Whether you are using the Report Filter or the new ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Here we have set the Top 10 Filter to Sum of Outstanding balance and set the value to 1,500,000: Our PivotTable now shows us the shortest list of customers to generate a total over £1.5m: Further ...

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

To fix an Excel spreadsheet not filtering correctly, ungroup its sheets, apply the filter to its entire spreadsheet column, and unmerge cells.