I’m trying to do some fairly basic data manipulation, but struggling no end trying to work it out…
Let’s say I have a data type called ‘stock’ which stores all the stock for all my merchants:
I then have an order query, like the following (this is a list but I’m using a table to represent it):
From here, I want to return how much of each stock type my merchants have, and display that in a repeating group, grouped by merchant:
Of course, this isn’t my actual scenario, but a neat way to represent it. Any help would be greatly appreciated!