I'm trying to compare where a particular store's Count(CustomerID) fits within the average of a subset of stores.
In the table, i'd like to show how the Count(CustomerID) compares to the average +/- 5 of the store's ranked sales. So for example, if i'm looking at store 6, i'd want to calculate the % difference between Store 6 and the average for Stores 1 through 11. If store 7, stores 2-12; store 8, stores 3-13 and so on. What would be the expression to calculate the average across those stores based on the CurrYr_RankSales?
I'm assuming its Above() and Below(), but i'm at a loss on how to calculate it across the CurrYr_RankSales dimension.
