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?
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