The PivotTable clone is now ready for comparison analysis. You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. If the data source does not exist, create a new one. Click on any area on the newly copied PivotTable and change the data source by navigating to PivotTable Toolsв†’Optionsв†’Change Data Sourceв†’Change Data Source (Figure 3).В Select the data source (in this case, AdventureWorks Cube) pointing to a different environment (in this case, Production). With the PivotTable cloned, proceed to change the Data Source of the clone. Selecting the Rows, CTRL+C and CTRL+V copiesВ the data as text and not asВ PivotTable. Take note this is the only way to copy PivotTable. The PivotTable will now be copied toВ itвЂ™s new location. Figure 2 - Select Entire PivotTableД¬lick a cell in the same worksheet or create a new worksheet and hit ENTER. To clone this PivotTable, navigate to PivotTable Tools Optionsв†’Selectв†’Entire PivotTable (Figure 2). IвЂ™m using AdventureWorks Cube for this illustration and this is my existing PivotTable pointing to Test Server (Figure 1) Figure 1 - Analysis Services Cube PivotTable

to compare data between Test and Production environment? In this post IвЂ™ll explain a nifty trick that helps toВ cloneВ an existing Excel PivotTable and change itsВ data source without having to create theВ clone PivotTable from scratch. Ever came across a situation where you have to compare PivotTable data from same data source but from different environments, for e.g.

How to use pivot tables in excel 2013