'filter' a field prior to 'sum'
I have a particular 'parent to child' relationship in a solution. It is useful in the child to have products that are delivered by various routes together. However, I want to present in the parent a sum of product compositions by their separate route of delivery.
I had thought to do this by having a separate route calculation fields in the parent. Use 'Sum' to total the values is easy. But how to 'filter' by route and get a sum?