Order figures per Company and per order status

Hey Gliders

I hope someone can help here.
I have companies which relates to users and the users places orders with values.
each order has a single product with single value.
Orders go through various statuses or stages.
I would like to show each user/company their total order value per stage/status.

Is this possible in glide?

Yes, possible. You’ll want to use a Query column to match all the relevant orders, and then use a rollup through the query to sum the value.

1 Like

Thanks Darren,
Today I am learning Query Columns

1 Like