MDX Puzzle - 11 Apr 2000

How would you write an MDX query that returns the top three promotions for each state in the United States?

Russ Whitney

April 11, 2000

1 Min Read
ITPro Today logo in a gray background | ITPro Today

How would you write an MDX query that returns the top three promotions for each state in the United States for 1997? Format the result so that 1997 is the only column and the states are on the rows, with the top three promotions nested in each state.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like