Choose a data source for the PivotTable list.
Use an existing data source control
Click inside the PivotTable list to activate it.
Click the hyperlink that says Click here to connect to data.
On the Data Source tab, select Data source control, and then select the control that you want from the drop-down list.
Under Use data from, click Data member, table, view, or cube name, and then select the element you want from the list.
Change a connection to a data source
Click inside the PivotTable list to activate it.
Click the hyperlink that says Click here to connect to data.
On the Data Source tab, select Connection, and then click Edit.
Select the OLE DB provider you want to use to retrieve the data, and then click Open.
Under Use data from, do one of the following:
To use the data from a specific record source within the data source, click Data member, table, view, or cube name, and then select the element you want from the list.
To use a query or command (such as an SQL statement) to select the data, click Command text or SQL, and then type the query or command in the box. For information about the query syntax, see the documentation for the external data source.
Finish the PivotTable list by customizing the layout and using the toolbar. Use the Commands and Options dialog box in the PivotTable to add totals, set properties, and so on, until the control looks and behaves the way you want.
Create a connection to a new data source
Click inside the PivotTable list to activate it.
Click the hyperlink that says Click here to connect to data.
On the Data Source tab, select Connection, and then click Edit.
Click New Source, then click Open, and then choose the type of data source to which you want to connect.
Finish the PivotTable list by customizing the layout and using the toolbar. Use the Commands and Options dialog box in the PivotTable list to add totals, set properties, and so on, until the control looks and behaves the way you want.
Note For more help on how to design and use a PivotTable list, click Help on the PivotTable toolbar. If the toolbar is not visible, in the Commands and Options dialog box, on the Behavior tab, select the Toolbar check box.