complexe aggr expression

[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  

EST  = 153 344 km 

OUEST = 58 258 km 

can someone help me please 

[abhijitnalekar]

Hi @francois_974 ,

Can you please share the sample dataset

[francois_974]

Hello

thanks for your reply

the data file join here . it's a fuel statement that i encrease monthly . 

i've got few pb because we change the fuel provider thats why i use the "date2" instead of "date de transaction" 

 do not hesitate ti join me if it wasen't clear

Francois