PS - here’s what it could look like using the client-side aggregating.
The difficulty is there are limited event hooks to refresh the calcs. For example, how do you refresh whenever the grid refeshes? There’s no reliable onRefresh/onFilter event hooks that I’m aware of.
Worse yet, it appears there may be some (possibly new) conditional client-side filtering go on in 2025.2. Which is a good thing, but more reason additional hooks are needed. Without a hook, you may have trouble even making Alisa’s Summary BAQ method work reliably - assuming you want to support recalc upon ad-hoc grid filtering(?) << Hope I’m wrong on this.