How to populate all items in a dataset with aggregated (Sum) data from another dataset?

Thank you for your response.

I wrote a response above. The example you wrote for me already works fine. I can make the dynamic page display data fine.

It’s on the Vendors All page where I am struggling to pull data, update the data and then populate the entire repeater for all vendors.