I am using a slicer with my pivot table.
The results shown in my pivot table are correct and reflect the setting of the slicer.
However, if I click on any value on my pivot table, the results that are shown ignore the slicer setting?
For example, the value in my pivot table 3 but when I click on that, I get 5 records returned because it shows me all the records.
Any idea how I can stop this from happening?
I'm restricted to using Excel 2010 due to this being something I'm doing for work.
The results shown in my pivot table are correct and reflect the setting of the slicer.
However, if I click on any value on my pivot table, the results that are shown ignore the slicer setting?
For example, the value in my pivot table 3 but when I click on that, I get 5 records returned because it shows me all the records.
Any idea how I can stop this from happening?
I'm restricted to using Excel 2010 due to this being something I'm doing for work.