Get the last one in stock

[fkeuroglian]

Hi Exper

I have a stock values and i want to get the last value of stock, for every date,Prod and Place

i have a lot of values for each date, product and place, and i want to show only the last one(for this combination)

i want to create a table with this information

attached the excel

thanks a lot

[sunny_talwar]

May be this

Sum(Aggr(If(Date + Time = Max(TOTAL <Prod, Place, Date> Aggr(Date + Time, Prod, Place, Date, Time)), Sum(Stock)), Prod, Place, Date, Time))

[devarasu07 · Accepted solution]

Hi,

like attached?

=FirstSortedValue(Date,-RowNo)

[effinty2112]

Hi Fernando,

Maybe:

Date	Prod	Place	Aggr(if(Rank(Time)= 1, Stock),Date,Prod,Place,Time)
16/05/2017	11786	1819348	5
30/05/2017	11786	1819348	5

Cheers

Andrew

[antoniotiman]

Hi Fernando,

maybe this

Note : In Script LOAD

...,Time(Time) as Time,...

Regards,

Antonio