Using slicers, it is possible to control multiple Pivot Tables and Pivot Charts at the same time. This is useful when you are setting up a dashboard and you want o create multiple reports and charts but they must all change together when you choose an option.
In this lesson you will learn
- How to link Pivot tables and charts via a slicer
- How you can set up a slicer on each page and the main page, and the slicers will be interchangeable and you can click on any one of them to change all Pivots.
To see the full course contents click here.