• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Creating PivotTable Queries > Creating a Two-Dimensional PivotTable

Creating a Two-Dimensional PivotTable

A one-dimensional PivotTable approaches the data from a single viewpoint. In the examples you've seen so far, the Employee table's Last Name field provided a focus for examining data such as units ordered and the discounted price. By looking at the totals for this data, the PivotTable makes it easy to compare the employees order-taking performance over the year.

However, the beauty of PivotTables is that you don't have to focus on just one aspect of the data. Instead, you can add a second viewpoint that breaks down the existing data into its component parts. For example, you might want to see a breakdown of which shipping company was used for each order. You do this in a PivotTable by defining both a row field and a column field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint