Forum Discussion
Drop Down List Filter Question
Hi (politeness obliges me ) Reception305
Why not putting in place https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d on your "Master" Table, instead of drop-down lists?
Sure I can share a workbook with some dummy data on it
https://oceanpeaceinc-my.sharepoint.com/:x:/r/personal/reception_oceanpeaceinc_com/Documents/Inventory%20Item%20list%20Dummy%20mockup.xlsx?d=w052e1f25e86541949767153194719f53&e=4%3adaaa066092f24d58b47474d26d6b1412&sharingv2=true&fromShare=true&at=9
Hopefully the Link works, If it doesn't I'll attach the file just in case
A possible way to go is attached. There's a setup_sheet to set the rules & TableSlicer with a couple of calcs. to determine what slicer has been used first + hidden columns on the main sheet
As you probably already figured out there are necessarily some conflicts, i.e: if you say dates should be hidden for Beverages (has Vendors: Costo, Amazon & Safeway) and you say dates should not be hidden for Costco (???). As you have more Categories than Vendors I assumed you would use the Category slicer first and implemented the corresponding logic in TableSlicer
It's not 100% perfect though. If you filter by 2 slicers you may get the following:
something I couldn't resolve
BTW, in almost all formulas I had to TRIM as you have leading spaces here & there
I wish I could make it 100%... Glad it helped anyway
- Lorenzo yeeea I had a feeling it would be something like that. Although, it's not 100% it does get the job done and solves the issue I was facing. Thank you for all your help!!!!!! The formulas you provided in the file were great!!!!