Forum Discussion
pivot tables copy
Hi Billy,
When you creating the pivot table if you select "Add this Data to the data model" which option is ON by default, your source data tables(s) are linked with data model, and pivot table works on data model table, not on source one in Excel sheet. Adding more pivot tables you connect them also to the same data model.
If you add grouping in one of pivot table you actually add one more column to the data model table which is visible for all pivot tables. You may use it, may not. The only you can't create let say Group1 in first pivot table with one fields and have Group1 with another fields for the second pivot table. Group1 is defined in data model and all pivot tables take it from the model.
You may use different naming to avoid the conflict. Or don't add your pivot tables to data model when you create them.
Hi Billy,
When you creating the pivot table if you select "Add this Data to the data model" which option is ON by default, your source data tables(s) are linked with data model, and pivot table works on data model table, not on source one in Excel sheet. Adding more pivot tables you connect them also to the same data model.
If you add grouping in one of pivot table you actually add one more column to the data model table which is visible for all pivot tables. You may use it, may not. The only you can't create let say Group1 in first pivot table with one fields and have Group1 with another fields for the second pivot table. Group1 is defined in data model and all pivot tables take it from the model.
You may use different naming to avoid the conflict. Or don't add your pivot tables to data model when you create them.
Thanks Sergei!
