jaydee
11-03-2016, 03:43 PM
When using multiple filters in a pivot table, it is possible to see items just related to the previous filters in the dropdown list?
For example, I have a pivot with 1000 vendors. I select one salesperson and I know he sells to 95 vendors. After filtering on his name, I select the vendor filter dropdown list and it shows 1000+ vendors, not just the 95 related to him.
My question is, is it possible for Excel to just show those 95 vendors, as opposed to showing all 1000 which isn't relevant to him?
Thank you,
For example, I have a pivot with 1000 vendors. I select one salesperson and I know he sells to 95 vendors. After filtering on his name, I select the vendor filter dropdown list and it shows 1000+ vendors, not just the 95 related to him.
My question is, is it possible for Excel to just show those 95 vendors, as opposed to showing all 1000 which isn't relevant to him?
Thank you,