Change the data source for this PivotTable to use the table named CustomersTable. On the PivotTable Tools Analyze tab, in the Data group, click the Change Data Source button. Type CustomersTable in the Table/Range box. Click OK.