Hi,
I am trying to return results based on a user's selection (maybe a tickbox selection). I have attached a sample file.
I want to be able to filter a list of content from my inventory.
1. If I only have box 1, then only return contents results where box 1 appears (lines 2-4)
2. If I only have box 2, then only return contents results where box 2 appears (lines 5-7)
3. If I have both boxes, then return all results
I tried doing this with pivot and slicers but I couldn't get option 3 to work properly.
What is the best way of doing this please?
Thanks!
Bookmarks