Section access to provide access to all data to a few users
I am trying to create a document with section access. I am using a reduction field to reduce the data on inital load based on user login. I need a way to display all the data to most of the users and only selected data to a few users. For example:
I am putting in section application section the following:
(ooxml, embedded labels, table is [User-Group]);
(ooxml, embedded labels, table is [Group-Permissions]);
In the Group-Permissions sheet, I have the following:
My question is on group 4. My data has more than 20 currencies. I want GRP4 to be able to view all these 20 currencies and GRP1, GRP2, GRP3 only 1 currency each as per the table above. I have tried using * but that essentially means that GRP4 will be able to access only USD, GBP and JPY. I tried leaving it blank but in that case GRP4 doesn't get access to any currency.
Please let me know if there is a way to solve this.