Microsoft Office Tutorials and References
In Depth Information
Notice that the PivotTable Fields task pane is a bit different when you're working with the Data Model. The task
pane contains two tabs: Active and All. The Active tab lists only the Orders table. The All tab lists all of the
tables in the workbook. To make things easier, right-click the Customers table and choose Show in Active Tab.
Then do the same for the Regions table.
Figure 18-49 shows the active tab of the PivotTable Fields task pane, with all three tables expanded to show
their column headers.