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
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.
About the Author
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