Hide sensitive data while keeping aggregations available
I have some sensitive information (salary) on my company which I don't want all users to see. However, some users must see total level (for example sum of salary by department…).
Let's suppose the detailed data is stored on a module A, and aggregations are calculated in module B (so it picks up data from module A). If I set "none" as a role access for module A, can users see correct totals on module B? Otherwise, what could be a solution to hide these data?
Thanks for your help.