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?

​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?  Read More

​