When you create exceptions by location, remember that:
A formula or grouping measure at the top location where the exception is defined contains all measures outlined in the exceptions below it. Otherwise, the overall performance measure at the top of the view does not reflect performance values.
For example, a company that manufactures and sells auto parts may only sell what they make at their location. The top location includes all parts sold in their Sales formula, but the various sublocations include only the items that they actually sell.
Use a default formula when the majority of locations use the same measures in a formula. Use a default submeasure definition when the majority of locations measure the same set of submeasures.
Default formulas and submeasures are designed to save time. If the majority of your locations contain the same measure definitions, use the shared definition as the default. Then, define exceptions to that general rule. Default formulas and submeasures apply to every location unless otherwise excepted.
A formula or grouping measure at the top location where the exception is defined contains all measures outlined in the exceptions below it. Otherwise, the overall performance measure at the top of the view does not reflect performance values.