Michael W Stark

Count Pivot and Rank Example

• The Grid displays data from the query in the textbox at the bottom.
• The data is sortable by clicking on the column headers.
• The query rolls up the sales numbers by quarter and counts the number of orders and customers.
• The query also returns the number of customers by product category.
• Finally, the query ranks the sales by quarter.