Forum Discussion
Solved
Three pivot tables
I have to create essentially the same pivot table 3 times, but the only variable is that I need one to show days, the other to show weeks, and the last to show months. The problem I encounter is whe...
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.
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.
- Thank you! The add data to data model worked.
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.
