MS Access for the Business Environment: Create a PivotChart View in Access - Page 4
August 4, 2003
Defining the Data Fields within the PivotTable View
Remaining within the Queries section of the Database window, let's take the following steps to begin construction of our new PivotTable view.
After a few seconds, the blank PivotTable appears, with a floating PivotTable Field List appearing in the foreground, as depicted in Illustration 8.
We discovered in our previous lesson how the PivotTable allows us to define the data values that we wish to occupy multiple rows, columns, pages and summaries. Let's define our view to effectively present the data set returned from our new query, in preparation for transforming that presentation to the more graphic PivotChart view.
NOTE: If the PivotTable Field List does not appear, initialize it clicking the Field List button, shown in Illustration 9, on the toolbar.
We see the Region field appear in the Filter Area of the PivotTable (the upper left hand corner).
This adds the Company Name field to the right of the City field in the column area of the PivotTable.
A small sample of the PivotTable view is partially shown in Illustration 11.
Now let's make our PivotTable more useful by adding calculated detail fields and totals.