Hi,
I have 2 slicers from a pivot table depicting 2 charts. Is there a way that I can disable a slicer when the other slicer is clicked/active.
Example: One slicer shows the quarters in a year (Q1, Q2, Q3, Q4) and 2nd slicer shows the months. Selecting Q1 should display under months slicer as Jan, Feb, Mar. But at the same time, clicking on another month (say December) should be disabled.
Please advise.
Nilesh
Bookmarks