Hello,
I have two pivot charts on 1 worksheet.
Pivot 1 Pivot 2 True/False Form
Returned Goods Total Goods
200+ List of customers 2000+ List of customers
That is the basic setup of my excel worksheet. I have a true or false command to tell me which of the 2000 total goods is part of the returned goods. This part works fine however I want only Trues. I want only total goods that are on the same list as the returned goods. When I run a filter to only give me "Trues" it changes the data in both Pivot 1 and Pivot 2. Any ideas on a more efficient, easier, way to do this. A way that wont change the data in pivot 1 only pivot 2.
Thanks
I have two pivot charts on 1 worksheet.
Pivot 1 Pivot 2 True/False Form
Returned Goods Total Goods
200+ List of customers 2000+ List of customers
That is the basic setup of my excel worksheet. I have a true or false command to tell me which of the 2000 total goods is part of the returned goods. This part works fine however I want only Trues. I want only total goods that are on the same list as the returned goods. When I run a filter to only give me "Trues" it changes the data in both Pivot 1 and Pivot 2. Any ideas on a more efficient, easier, way to do this. A way that wont change the data in pivot 1 only pivot 2.
Thanks
