Get last sorted record

[mato32188]

Hello guys,

I would like to create a pivot table in which you can get the last balance of product and its version as the last value of all values. See in my attached xls file. One product and its version could be located at more than one Place and also within Place in more than one PlacePoint.

Dont need to know last balance of the day, only get last balance of product and its version.

Final Pivot:

Product     ProductVer           balance= calculated as a sum of balances at all places and placepoints

L111            ver1                    200pce

L111            ver2                    150pce

L133            ver1                    20pce

I tried to use the firstsortedvalue, but it returns some other values i want to get.

Thanks for your help,

Martin

[tresesco]

Did you try = FirstSortedValue(Balance, -Timestamp) ?

[#3]

Let me know if i'am correct:

you would like for product+version find sum of last balances from each place+placepoint?

regards

Darek

[mato32188]

Lets say, I would like to sum up all last balances at different placepoints for each Product and its version...

Need to find last Balance for each product and ist version, does not matter, where it is located...

Like for Purchase, you need to know the last balance of Purchase Product, no matter, where it is.

[#5]

ok i will try to help you....

[mato32188]

Helpful, it returns last balance of Product and its version sorted by timestamp descending, am I right?

But I need to know all last values for those products and versions, that could be located in different places and placepoints. Find last records for Product and its version at different Places and PlacePoints and sum up those balances.

[mato32188]

Dziękuję bardzo

[#8 · Accepted solution]

try this,

regards

Darek

[mato32188]

Did you upload anything Dariusz?

I cant see it.

[#10]

i attached example.