• subscribe
August 21, 2002 12:00 AM

September 2002 MDX Puzzle

SQL Server Pro
InstantDoc ID #25956

This month, I'm going to pitch a nice slow one right down the middle, and I expect everyone to hit it over the center field fence. Using the FoodMart 2000 Sales cube, write an MDX query that displays each product category and its average month-to-month store sales growth for 1997. Place the product categories on rows in descending order regardless of their product department groupings. In other words, the product category with the best average monthly growth rate in 1997 should be the first row displayed in the result. Format the average growth rate as a percentage with two decimal places of accuracy.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here