how to avoid ungroup in one pivots changing other pivot tables in the same workbook?

Copper Contributor

I have 3 pivot tables in 3 different sheets of the same workbook. Once I ungroup or re-group in one pivot table. the others all changed. How can I do to avoid changing the other pivot tables?

Thank you! 

1 Reply