What happend to the top 10 products previous years ?

I have written previously about the TOPCOUNT() function and in this blog post I will extend that with the previous development for the top 10 products.  This is also the second part of my previous blog post about analyzing product volatility.

Let us start with the TOPCOUNT function and later extend that with a calculated measure using the RANK() function.

Here we have the top 10 selling products, for the year 2004, in the Adventure Works cube.