I have a custom field in Opportunity Product called 'Unit of Measurement' and what I am trying to do is, show one value "Meter" as the default for users of one profile and "Square foot" as the default for all the other profiles. What is the best way to accomplish this in such a way that this doesn't affect reporting on that field?
Edit: In the 'Unit of Measurement' Picklist field in Opportunity Product, the default is set as 'SquareFoot'.
The use case is, when users with 'China' profile try to add a Product to Opportunity, the 'Unit of Measurement' Picklist field should default to 'Meter'. When any other profile user tries to add the Product, the default value should be 'Square Foot'. Right now since the default value is set as 'Square Foot', users with 'China' profile who forget to change the default are saving records with 'Square Foot' as Unit of measure.