I have multiple pivot tables and each of them is linked to one or two slicers. They adjust when I filter by values or conditions but when I want to go to another sheet of my document.
The problem is that in a third sheet I have a table that resumes the information in my pivot table: but in this third sheet the slicer is not applied so instead of having just the data that I've filtered, I have all the information.
I know that you can freeze the values of the slicer but when I click on the three little dots, it does not ask me to set the current filters by default.
Can someone help me with this issue?