How to display the intersection of my collections in a gallery (using a site menu)?

Hi all,
I am building my own site with my product collections displayed in galleries. I’ve attached a mockup with dummy examples below which I hope makes my question simple to understand. There are 2 ways to select products: by brand, let´s say, (which are horizontal graphical buttons) and by type of item (which is a vertical site menu):
T-shirts
Bags
Shoes
etc.

What I want to do is display the subset of products which would correspond to the brand the user selected and the type of item selected, for example, Nike shoes.

I have been researching but can´t understand how. I am aware that filters are an option in a gallery, but I don´t want to go that route. It´s not the same functionality as making a selection from a site menu, and I don´t like the checkbox interaction and visual style and placement. And I don´t want to use a drop down and obscure the other choices, I want to use a site menu. Can anyone direct me to any information or tell me what would need to be programmed?

Any help would be really appreciated. Thanks in advance.
Erica

Do you want to display it in a table?

Hi J.D.,
I’m displaying images of the products in a grid gallery…

So first get all the items from the datasets:
https://www.wix.com/velo/reference/wix-dataset/dataset/getitems

Once the user selected filter(s), use filter the dataset based on brand and/or type:
https://www.wix.com/velo/reference/wix-dataset/dataset/setfilter

Thanks so much J.D.! It’s after midnight here so my brain may not be fully functional right now, but I’m thinking that will work for the brand selection determined by the top buttons that can connect to datasets, but will it work for the user’s selection of item type on left hand vertical menu, which is actually a site menu, built from the visible site pages? Sorry if I’m missing something…
Thanks so much,
Erica