View Sales Data by Quarter Previous Topic

Previous Page 		Next Topic

Next Page

Suppose you want to compare the total sales figures of each product by quarter. You can have the PivotTable Wizard create another PivotTable from the same query that displays the sales performance of each product (ROW area) by order date (COLUMN area). When the wizard finishes, edit the PivotTable to group the data by quarter.

Two screenshots: first shows sample PivotTable open in Microsoft Excel for editing with Grouping dialog box displayed; second shows the edited PivotTable.

Tip Icon

 Display specific products; hide those you don’t need   Click the Edit Pivot Table button on the form, select the rows of products that you want to hide, click Row, and then click Hide (Format menu).

Sort Descending button Sort Descending button

Rank products from most to least sold   Click Edit Pivot Table, select the products you want to sort, and then click the Sort Descending button.

Next Steps

  To See
  Learn more about queries Evaluate Sales Performance in a Microsoft Access Database
  Display data visually Create a Chart from a Database

Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.