0
Duplicate of Grouping a field in one pivot tables groups the same field in another table, although the solution given there does not work in Excel 2013.
I want to have separate pivot tables so that I can filter and group the data separately in each. How can this be done?
Dr. John A Zoidberg
Posted 2016-08-08T08:25:37.953
Reputation: 399
-1
Pressing ALT+D then P should open the PivotTable/PivotChart Wizard in Excel 2013
Another alternative is to click insert at the top and then you have the option of creating your own pivot table or selecting a recommended pivot table.
Chris Rogers
Posted 2016-08-08T08:25:37.953
Reputation: 1 153
0
Basically, when creating a pivot table, Excel makes a copy of the data source in a cache, which is then the source for the Pivot tables. (BTW: that's the reason why, when changing datas in your source, it doesn't actualize the Pivot table automatically).
Normally, Excel use the same cache for all pivot tables, if it comes from the same source. Having groups of fields in a pivot, impact therefore other pivot tables with the same field.
There is a however a workaround using the PivotTable/PivotChart Wizard
visu-l
Posted 2016-08-08T08:25:37.953
Reputation: 426
using insert to create pivot tables keeps formatting between them, even on Separate worksheets. – Dr. John A Zoidberg – 2016-08-08T08:48:30.640
It's not clear how your post tries to answer the question, please explain it. – Máté Juhász – 2016-08-08T13:09:38.650
The OP wanted pivot tables and mentioned a solution in a previous post which I have said should work but offered an alternative – Chris Rogers – 2016-08-08T13:15:25.080