A common type of retail sales analysis is consolidation analysis. One example of consolidation analysis is Customer consolidation analysis: If fewer customers are buying more products, your customers are consolidating. If more customers are buying fewer products, your customers aren't consolidating. Using the FoodMart 2000 Sales cube, write an MDX query to determine whether the top 10 FoodMart customers are consolidating throughout the four quarters of 1997.
To solve this puzzle, you need to create an MDX query that includes the four quarters of 1997 on the columns of the query's result. Then, create two rows. The first row should display the total number of store sales attributed to the top 10 customers altogether. The second row should display the percentage of total store sales attributed to the top 10 customers altogether.