I have a specific requirement for security restriction for client.
Case 1) The users with access to all organization level can see all the data underneath except the profit field.
This ca be handled using the Omit clause.
Case 2) special users who have access to unit Level can see the Profit Field.
Now most tricky part is the same user can exit in the both the cases.
Hence if user1 has access to Area - North , he should be able to view all data excet Profit field.
and as Special user, he can have access to unit- Finance then he should be able to view profit field.
When I tried this using Omit, it doesn't work as it omits the field entirely.
Are any workaround or alternative.