hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Morning all,
Had a search and could not find an answer.
I have a sheet with three pivot tables on it. All sourcing data from the same table. The table has three company names within it. I want each pivot to show the data for the individual companies. However, if I select a company name in the Pivot Table field lists filters, then all three pivots are auto changed to the same selection.
Any suggestions? Or is it just not possible?
Had a search and could not find an answer.
I have a sheet with three pivot tables on it. All sourcing data from the same table. The table has three company names within it. I want each pivot to show the data for the individual companies. However, if I select a company name in the Pivot Table field lists filters, then all three pivots are auto changed to the same selection.
Any suggestions? Or is it just not possible?