Sum values in a field by unique instance of another field

[JeffMelon]

I am trying to sum Loads by the unique instances of each Lane ID, I tried using sum distinct but that gave me 28, not 31.

Not sure if I should be using set analysis for this, can someone share their thoughts on this?

Thank you

[BrunPierre · Accepted solution]

Hi, try this.

=Sum(Aggr(Only(Loads), Lane, [Lane ID], Loads))

[JeffMelon]

Thank you, this worked perfect!