Aggregation issue

[francois_974]

Hello all

i've a issue and i can't fid the solution myself . thanks for helping.

I load data contain the fuel statement by date of my véhicle like this

affectation,vehicle registration, date, kilometrage, amount, volume

i made a table like below to calculate the différence (Ecart) in km like that (firstsortedvalue (Kilométrage, -Date2)-firstsortedvalue (Kilométrage, Date2)

i would like to aggregate the Ecart for a special dimension but i can achieve this . (sum of the "Ecart" by "affectation")

for example i would find the total of km like that

EST = 153 344 km

OUEST = 58 258 km

can someone help me please