You want to display subtotals for three columns to analyze the averages. Use the Subtotal feature to calculate the average selling price, percentage of asking price, and days on market by city. Ensure that Summary below data is selected, and then click OK. Group the data using the Auto Outline feature. Collapse the outline to hide the listing and sale dates. Click the outline symbol to display the grand average and city average rows only. Now you are ready to format the data and set a print area to print only