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

In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER () function. In several spots, you’ll read “AND and OR,” which is grammatically awkward.