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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |