Forum Discussion
NatashaElsley
Jul 11, 2024Copper Contributor
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?
- NatashaElsleyCopper Contributor
Kidd_Ip thanks, how do I implement it?