Filtering an array based on multiple conditions, without iterator and filter?

Thank you.

This is the scenario screenshot.

There’s only one source array, but for every metric I want to appear in the reports (for instance, total value of all transactions that were authorized in USD), I need to iterate the array, apply the filter and sum it.

I’d love to be able to sum such filtered values in a single step.