On the attached worksheet you will find a sheet entitled Supplier Overview
You will see two separate pivot tables. At the moment I have to change both Suppliers separately.
Can some one tell me away of changing the supplier for both pivots from one drop down/ slicer etc?
Also can any one help me with a formula to go in cell L:10
The formula needs to count the number of customers in column A. Obviously this number will change when the chosen supplier is changed on the main pivot/slicer.