What happens when we need to rank using multiple criteria? In the example below, we are going to look at resellers by name and key in a SalesTerritoryGroup, and we are going to rank them based on the number of items they have sold.
Let’s start with the model. I did slightly modify Rob’s original 3 table model approach. I now have 5 tables here, but the model conceptually still works the same. I have a sales table, a date table, a resellers table, and two lookup tables, one for geography and one for sales territory.
Read the whole thing.