We have structure like below:
| User | Product | Client | Revenue |
|---|
| A | has access on PROD1 and 2 | Client according to product access | Revenue based on access |
| B | has access on PROD3 and 4 | Client according to product access | Revenue based on access |
| C | has access on all Products | Client according to product access | Revenue based on access |
| D | has access on PROD1 | Client according to product access | Revenue based on access |
We are restricting data which user can see at front end based on Lock Fields logic and we are not using section access.
In above case lets say User A logs in and we have locked field Product for only PROD 1 and 2. Now requirement is like We want to show Grand total of client wise revenue to User A for comparison and which should change according to client selected.
There are hundreds of other fields available but this requirement of showing grand total of revenue only with respect to Client. How can we achieve this when we have locked PROD fields for particular user.
