Our Salesforce admin set up two different record types for Opportunity. 1) General 2) Overseas
We have these scenarios to meet:
1) User 1 with Profile 1 to see all the fields of Opportunity. 2) User 2 with Profile 2 to see all the fields of Opportunity except Amount 3) User 3 with Profile 3 to see Amount field in Overseas Opportunity record type but not on General record type.
My approach was to use field security level and page layout. Only problem is that although User 3 has a page layout without the Amount field in Overseas Opportunity record type, User 3 is still able to pull reports with Amount field.