Calculated fields and level-aware aggregations

I have a following situating:

Filter: select list customerId

calculation field: distancePerCustomerId
((maxover(max(distance),[customerId]) - minover(min(distance),[customerId])))

Now I need sum the distancePerCustomerId results:

calculation field: distancePerCustomerId

Thanks for all help!

Hi Izabel. We have an upcoming ask the expert session on level aware aggregates. See the invite here: Ask the Expert - Level Aware Aggregates (April 1st at 11:30am-12pm PT). If you aren’t able to join then we will also post the session in this section of the community in the coming week: Ask the Expert - Amazon QuickSight

Here is the session: Ask the Expert - Level Aware Aggregates. Let us know if you still have questions