A simple and valuable way to measure a store's performance over a given year is to create a line chart containing the store's unit sales for that year. If the chart includes other lines representing the best- and worst-performing store for each quarter in that year, it can tell you whether the store in question was consistently near the bottom or top of the pack for each quarter in the year.

Use the FoodMart 2000 Sales cube to create an MDX query that compares the unit sales of the Beverly Hills store against the best- and worst-performing stores for each quarter in 1997. The worst store's performance must be greater than zero to filter out stores that had no sales in that quarter.