Hi,
In the report, I am comparing client and it's peer group data for few attributes. This report is RLS enabled, so the users can see only those records for which they have access.
But the requirement is that users should see those records for which have the access and also want to see the aggregated data for remainig records. these aggregated records are required as this report shows the comparison of a selected client with rest of its peer group.
| User | Client | Product | Ranking |
| A | ABC | X | 3 |
| B | BAC | X | 2 |
| E | CAB | X | 6 |
| A | BCA | Y | 2 |
| D | CBA | Y | 4 |
| E | ACB | Y | 2 |
By considering the above sample data, If user A logins in the report and want to compare the rank of product X for client ABC then it should show rank of product X for client ABC and compare it with the average of ranking for rest of the clients (BAC, CAB) for same product X.
As RLS implemented, so user A can see the records only for ABC and BCA clients but the requirement is User A should be able to see aggregated data (no other details like client, product details) also for the clients for which it doesn't have the access.
Please suggest if there is any way possible to achieve this.
Thanks
