Section access only on expression

[passionate]

Hi Geeks,

Requirement:

I have different sets of User having below access:

ACCESS	USERID	Priority
ADMIN	1
USER	2	Priority GB clients
USER	3	CMB
USER	4	Non-Profit GB clients

Data:

Attached in excel

I have a straight table given below:

If i login with USERID :2.

I have access only to Priority GB clients

So,I require table showing sum(Sales) for Priority GB clients and for other priority it should show '0'

But, As per section access it is reducing Priority Records:

Any solution so that only expressions are affected by section access.

Thanks,

Pankaj

[karthikoffi27se]

Hi Pankaj,

As per section access, it only shows as per the access given. Unfortunately there is no option to show the other fields with zero value.

Many Thanks

Karthik 

[marcus_sommer]

It's not possible with a normal section access implementation.

Thinkable is to chain the access rights to the data without section access and to query the user within the expression with something like:

sum({< AccessList = {"$(=osuser())"}>} Value)

I could imagine that a quite similar solution might be possible with section access in the way like the access-control worked by sheet- and/or object-level access by using a 0/1 flag against the data which might result in an expression like:

sum(Value) * AccessFlag

But both described approaches and similar ones are not really secure because the data itself will be available within the application. This meant it will be only some advanced kind of usability.

An alternatively could be to mask the data with section access like this way: Mask or de-identify data for certain users using Section Access.

More to section access: Section Access.

- Marcus