Hi all,

I'm having a problem grouping items in Pivot Tables.

I need to make multiple PTs and then charts to display different data. However all the PTs are derived from the same data list.

Now for one Pivot Table, I want to sub group my company list by the top 5 companies within an Industry . . . But for a second PT, I want to sub group top 5 companies by state for a different approach.

However when I go to create the second sub group from an entirely different PT than the first (but derived from the same data list) it then changes the original and every pre existing company sub group from my previous PTs.

How can I create sub groups in different PT that are independent from one another?

Thanks all!