aggr sum in both lines of hierarchie

[SwenWa]

Hi community,

I need help with AGGR & SUM:

• I have the following simplified table (black).
• The Aggr function (red) i tried: sum(aggr(sum(distance), ID, Line)) 
• In green is the expted result. Sum of distance for every combination of  ID & Line combination

ID	Line	Position	distance	AGGR function	expected result
79	13	1	10.000	10.600	10.600
79	13	2	600	-	10.600
47	12	1	917	917	917
47	13	1	917	917	917

Thanks for your help in advance! 🙂
Swen

[tresesco · Accepted solution]

This?

sum(aggr(NoDistinct sum(distance), ID, Line)) 

Or,

SUm(Total <ID, Line> distance)

[SwenWa]

SUm(Total <ID, Line> distance) works fine on a first look.

I did not think that it could work without aggr() 😉