Hello Team,
In the Incident table, the location field is correctly filtered based on the selected company using a reference qualifier. However, when running a report on the Incident table and selecting a location, it shows duplicate entries like two ‘South Africa’. I want the location to be displayed only in relation to its company. For example:
- Company: Airtel → Location: South Africa
- Company: Vodafone → Location: South Africa
Would you like me to also suggest possible solutions for this issue in ServiceNow, such as how to handle duplicate locations in reports?
