The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total (Calculation)
Filter: Return only the TOP 10 Products based on Internet Order Quantity.
Hint: Use the WITH MEMBER statement to perform the calculation. In addition, you will need to you the ROOT function or [ALL Products] to get the Total Quantity Ordered for the calculation. Your result set should resemble the following:
Remember, don’t post you solutions here. Save them for my solution post. I will post it along with the steps that was taken to solve the puzzle in a couple of days.
Don’t forget to check back in a couple days for the solution.
Talk to you soon,
Patrick LeBlanc, SQL Server MVP, MCTS
Visit www.BIDN.com, Bring Business Intelligence to your company.