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?

up vote -1 down vote accepted

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.

  • using insert to create pivot tables keeps formatting between them, even on Separate worksheets. – Dr. John A Zoidberg Aug 8 '16 at 8:48
  • It's not clear how your post tries to answer the question, please explain it. – Máté Juhász Aug 8 '16 at 13:09
  • 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 Aug 8 '16 at 13:15

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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.