Help when we lock selections for different users

[rsdhavle]

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.