Displaying a Pivot Table
Displaying a Pivot Table
To display an existing pivot table, do either of the following:
-
Click Open, expand folders as needed, select a pivot table, and click OK.
-
Select Pivots in the Model Contents area. Then expand folders as needed and select a pivot table.
The system immediately runs the query defined by the pivot table and then displays the results unless the Auto-execute option is off. In this case, click the Refresh button in the Pivot Builder area. The system then runs the query and displays the table.