Now the answer is “yes”: December 29, 2022 / SOC 2 Type II compliance, [This ...] in Formulas.
I think you can achieve the desired result, perhaps with the use of an extra auxiliary Formula Field (we still can’t do aggregations within the Filter(...) function).
Please ping us via Intercom if you need assistance — @Chr1sG or I would be happy to jump on a screen-sharing call.