Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Hi,
like attached?
=FirstSortedValue(Date,-RowNo)
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
Hi Fernando,
maybe this
Note : In Script LOAD
...,Time(Time) as Time,...
Regards,
Antonio