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