I have a nested data source of orders in JSON format. Each object contains an array of order_items, and each order_item has a quantity. So, this is a nested JSON source.
I am trying to sum the quantities within an order, but I can't seem to do this. As you can see from the image, if I use the selector "@/data/order_items/quantity;" it will create blank rows where there are multiple order_items in the object.
When I try to sum @/data/order_items/quantity, it returns the sum of all quantity and displays it only on the first row, when I want the sum of all quantities within a given row.
How do I get it to return the sum of the quantities for each row?