MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up a little with one that is a little more challenging. I have to be honest, this puzzle was sent to me by one of my co-workers at Pragmatic Works. Here are the requirements:
Columns: Reseller Sales Amount and using the Source Currency Code add a column to the result that displays US if the currency code is USD and International for all other currency codes.
Rows: Country and State-Province
Filters: None
Hint: You may need to use a CASE statement or the IIF function.
Tags: mdx