Hi there. I have a pivot table with a slicer to enable my users to filter data down to their department. This works, but when they double click the filtered amount in the pivot table, it actually returns ALL department data, not just the filtered department. Can anyone let me know what I've done wrong?