Creating ranking metrics

Now we know Touring-1000 Yellow is to blame; but there are also other underperforming products (so to speak). The bikes Product Manager and the Sales Manager are very curious to know the 10 less profitable products in our shop, in order to review the catalog, and come up with a creative way to cover losses. You are tasked with the "10 most money-losing products of all time" report. How would you do it? Well, yes, sort them and print just the first 10 lines could be an easy fix; but there's a more elegant solution. Use the Rank function.

Getting ready

My opinion is that in BI there is not only one "single" solution to reporting requests. Everyone has his/her preferences, we can get to the same results from different path and, as long as the numbers are true, there is no wrong or right way of doing things. There may be different performance issues and different levels of complexity, but the message is: if you can provide the correct number one way or the other it's...