MDX Puzzles: Encounters of the Fourth Kind

Since this week is Thanksgiving and I was busy as mess on Friday, I figured I would wait to post the solution to last week's MDX puzzle until today and take a week off from blogging while I celebrate Thanksgiving with the family.

To solve Encounters of the Fourth Kind, you needed to take advantage of two MDX functions: the Ancestor function and the IIF function. So lets start off with a base query that has Reseller Sales Amount on the columns and Products on the rows: