I have a worksheet with different pivot tables in several tabs, based on 1 data list.
I am using slicers to filter.
IN some tabs when I add several slicers, the slicer settings work (like hide items with no data = blanc button disappears). When I select 1 item in slicer 1, all irrelevant items in slicer 2 disappear. This is what I expect.
But on other tab sheets, when I add several slicers (the same often), the slicer settings do not work (like when I select "hide items with no data" nothing chages and the blanc button remains). When I select 1 item in slicer 1, nothing changes in slicer 2. All items remain, while not all of the are relevant for the item selected in slicer 1.
What am I doing wrong, while I am only doing the same