Fun with MDX-Part 1: Top 5 Products Per Country

So I have been spending a considerable amount of time the past couple of weeks getting up to speed on MDX. As I come across interesting solutions I want to take a minute to present them and explain how and why they work in the hopes that they will help you or someone down the road. For those that want to play along all of these samples can run against the Adventure Works 2008R2 cube.