If you know DAX or you read our book, you will find that a DAX expression can solve the issue. However, such a formula is more complex than necessary. The next version of PowerPivot might have more built-in DAX functions and should solve the ranking need with a simpler formula. In the meantime, it is interesting to know a different approach that relies on Excel skills instead of DAX ones. Alberto shows how to solve the issue without writing a single line of DAX. It is always useful to look for other ways to get the job done, and sometime this approach is more practical than trying to decode very complex formulas, especially in case you don’t have to refresh your data often!
You can find more info on www.powerpivotworkshop.com. Hope to see you there!