Hi All

I have a PowerPivot which I have created Slicers for. One of the slicers is called departments and I want the relevant manager to be able to see only his departments. I have pre selected the values for the appropriate manager but as there are over 20 departments in the organisation I only want him to see the two departments he is repsonsible for when he goes to his report sheet in the slicer.

Is there any way I can hide the slicers members even if they have data on them so the manager can only see the two departments which he is responsible for.

I hope this makes sense

Thanks