Creating A Filtered Subset Of A Data Table Using Controls Instead Of Slicers
Hello, me again. I've ran into some issues with pulling certain data from a table and was hoping I could recieve some help. It's hard to put into words exactly what I mean, but hopefully an example will get my point across.
Let's say I have the table:
| Category: |
Part: |
Volume: |
| Box |
001 |
1000 |
| Box |
003 |
3000 |
| Tape |
101 |
500 |
| Scissors |
201 |
300 |
| Box |
004 |
2000 |
| Scissors |
203 |
400 |
| Tape |
107 |
600 |
Example being if I choose [Box] with my combobox and choose both [001] and [004] as my part numbers a new/seperate table would be shown as:
| Category |
Part |
Volume |
| Box |
001 |
1000 |
| Box |
004 |
2000 |
I could then have a chart showing data from the new table.
I'm basically trying to create a Slicer but with comboboxes and listboxes. Any help is appreciated.
Thanks.
