A view can include a measure structure that remains the same regardless of location. Some measure structures differ, based on location. A specific location’s measure structure may share some measures with other locations. Use exceptions by location to create unique measure structures without creating a separate view to show each structure.

You can use exceptions by location to except, or exclude, specific measures from a view for a specific location. You can use exceptions by location to remove measures from a formula or grouping for a particular location. For example, after creating an exception by location, the Costs measure includes Admin Costs only at the Head Office location. All other locations calculate Costs using the Local Costs measure.

To properly represent the Costs measure at the very top location, include all submeasures of Costs. Otherwise, the drill-down path to Admin Costs is broken, and the value does not get rolled up.