Dependent Filters in an Excel Pivot Table: The Secret to Getting Them to Work
Dependent Filters are where you have two filters and the choices available in Filter 2 are based on the selection from Filter 1.
For example you have a list of Regions (EMEA, AsiaPac, Americas). You select a region (EMEA) from Filter 1 and you want Filter 2 to only display the countries that belong to EMEA.
Easy, right? Not with standard filters. But using Slicers it's simple. In this video I show you how.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:21 What Are Dependent Filters?
00:01:20 Add Slicers to a Pivot Table
00:02:00 Connect a Slicer to Multiple Pivot Tables
00:02:57 Hide Items With No Data
🗒 Notes and Resources
Download a copy of the file used in this video: https://share.getcloudapp.com/WnuDqZ7B
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#hashtag #excel #pivottable #filter