Question: Dependency between Repeaters

Hi,
I have a Wix problem which I hope some of you may have faced and potentially solved.
I have a products page where I would like to display them in a repeater. This is all easy and I have already done it. Now, I have categorised my products and would like 2 repeaters
Repeater No 1: Displays various categories horizontally. Each category is displayed as a button
Repeater No 2: Displays products per category based on the button click in Repeater 1.

From database perspective, I have got 2 datasets - Products and Product Category. Category Code has been set as a reference field in Products data.

Problem
I am unable to get the button click in repeater 1 to trigger repeater 2 to refresh.

Current workaround
The only way I have got this to work is as follows

Products Page - Repeater 1 displays all categories. Repeater 2 displays products across all categories

ProductCategory Dynamic Page: This page loads on click of a particular category and displays all products for that category in a repeater

I personally dont like it as its effectively 2 pages to do something which I could have done in a single page.

Surprisingly, If i replace repeater 1 with a table, I can get this to work as expected and this is the example provided in one of the support pages as well. However, the table doesnt look pretty and i would like to do it via repeater.

Question: Has anyone faced this and found a way to resolve the issue? I can code and therefore its not an issue if I need to use WixCode to do this. Any thoughts would be appreciated.

Thanks!

Regards
Venkatesh