Resetting Rank and Percent Metric Qualifications: Break By

The break by setting of a metric qualification allows you to choose the attribute level at which to restart counting rank or percent values for a metric. This level must be higher than or equal to the level of aggregation for the metric itself.

For example, given the following data:

Region	Market	Store	Actual Sales $ (in thousands)
Northeast	Mid-Atlantic	Baltimore	40
Northeast	Mid-Atlantic	Philadelphia	30
Northeast	New England	Boston	20
Northeast	New England	Greenwich	10

The metric is aggregated at the lowest level on the report, which is Store. Therefore, the break by value can be Market or Region, but not Store.

If you break by Market, the ranking counter is reset for each market (in descending order).

Region	Market	Store	Actual ($K) Sales	Rank
Northeast	Mid-Atlantic	Baltimore	40	1
Northeast	Mid-Atlantic	Philadelphia	30	2
Northeast	New England	Boston	20	1
Northeast	New England	Greenwich	10	2

If you break by Region, the ranking counter is reset for each region. In this example, there is only one region, so the counter is not reset.

Region	Market	Store	Actual ($K) Sales	Rank
Northeast	Mid-Atlantic	Baltimore	40	1
Northeast	Mid-Atlantic	Philadelphia	30	2
Northeast	New England	Boston	20	3
Northeast	New England	Greenwich	10	4