Hi I'm in need of some help.
I've created a Pivot table based on a TOPn Rankx result. It provides me with a list of the top 10-25 items sold. I want to use the results from that table to filer the products details pivot table.
I've been able to create VBA code but I can only filter the first item from Pivot table 1 into pivot table 2.
Or is there a way to use my RankX and TopN and select other fields.
When i drop in another field in the Rows it lists all Brands not just the filtered brands.
Thanks for reading
I've created a Pivot table based on a TOPn Rankx result. It provides me with a list of the top 10-25 items sold. I want to use the results from that table to filer the products details pivot table.
I've been able to create VBA code but I can only filter the first item from Pivot table 1 into pivot table 2.
Or is there a way to use my RankX and TopN and select other fields.
When i drop in another field in the Rows it lists all Brands not just the filtered brands.
Thanks for reading
