Hi
I have a technical question and was hoping someone would be able to assist.
I have a raw data file which combines three data sources and combines them into one. This then feeds into a pivot table with multiple report filters at the top i.e. users select their regions etc and view results.
Is there a way where I can set up a username and password with permissions for all users which would then only allow users to select the report filters that they have permissions for.
So for example Jo bloggs has access to region 1. When he selects region 2 from the dropdown on the report filter on the pivot, it tells him you do not have access.
Any help would be greatly appreciated.
Regards
I have a technical question and was hoping someone would be able to assist.
I have a raw data file which combines three data sources and combines them into one. This then feeds into a pivot table with multiple report filters at the top i.e. users select their regions etc and view results.
Is there a way where I can set up a username and password with permissions for all users which would then only allow users to select the report filters that they have permissions for.
So for example Jo bloggs has access to region 1. When he selects region 2 from the dropdown on the report filter on the pivot, it tells him you do not have access.
Any help would be greatly appreciated.
Regards
