Three ways to filter a pivot table and two of them you might not have known about. Daniel Bula asks if the trick from episode # 2359 can be used in a pivot table. Here is a great pivot table hack to filter to the south region over $5K.
Table of Contents
(0:00) Welcome and shout-out to Daniel Bula
(0:24) Excel Problem: Filter to South greater than $5K
(0:35) Filtering based on Sum of Sales in Excel
(0:50) Sorting on South
(1:00) Slicer based on the detail data
(1:20) Typing criterion below South column
(1:33) Customize quick access toolbar
(1:47) Filtering from cell below pivot table
(2:01) Clearing Filter from South
(2:20) Turning off Filter drop-downs in Excel
(2:32) Wrap-up