Forum Discussion

NatashaElsley's avatar
NatashaElsley
Copper Contributor
Jul 11, 2024

Power Pivot limiting filter options but still allowing filtering

Hi,

 

I have loaded some data into power pivot that I am using in reports going to different cost centres owners. I have filtered on the cost centres needed for each report but I want to stop the cost centre owners from being able to select cost centres that aren't theirs, though still be able to use the cost centre field to filter on their own cost centres and move that around as they see fit. Is it possible? How can I do it?

Resources