Forum Discussion
Three pivot tables
The easiest way is to add data to data model creating PivotTable
Other way is to separate caches, you may google for guidance, but I don't see practical reasons to use such method.
joshallen , you are welcome
Hi, I tried your method, but it didn't work. Do you have any other suggestions? When I try to group the second pivot table, a message appears saying: "it cannot group that selection". The group comes from the same numeric column as in the first pivot table, so I don't know what I'm doing wrong.
Above works if you have hierarchy as dates (year, month, dates).
Grouping of numbers or texts doesn't work with pivot tables if data added to data model. You may do that without adding data to data model but separating pivot table caches. You may google for more details, simple approach is
Create pivot tables without adding data to data model
- open new empty Excel workbook
- cut one pivot table (e.g. second one) and paste into new workbook
- change here grouping as desired
- cut pivot table in new workbook and paste it back
- close new temporary workbook
