Hi there! I would like to build a search that shows the sum of a particular price level / currency of Inventory items (Level = “Special Price”, Currency = “USA”) grouped by the Kit/Package item that this item is a Member Of, but I only want to see specific Kit/Package items based on criteria (e.g. “only Kits that have Custom Checkbox checked”).
In short: What is the sum of “Special Price” in USD for all components of Kit/Package Items where Custom Checkbox is checked on the Kit/Package Item?
Since I have to join the “Pricing Fields…” on the Inventory Item, I have to start with the Inventory Item level (because you can’t daisy-chain joins like that).
However, then I need to join the Kit/Package fields to be able to set criteria on that Custom Checkbox. There is a “Member Of” available as a field, but no corresponding “Member Of Fields…” join. Am I missing something, or is this not currently available?