Product Sales, Top and BottomCount in the same report

Here is a MDX code snippet that will show you how to combine named set based on TopCount and BottomCount. This type of report is sometimes refered to as "winners and loosers". This means that the report will show the best selling products and the worst for a single year.

It is also easy to use this code in others types of analytics like the products with most and least errors.

I will start this time with showing the final result.