Quantity of the last date in different dimensions

[#1]

Hello,

Im struggeling with a expression.

I have to find 2 things.

The date of the last record on three dimensions, this one a managed to get.

The second thing is the quantity of this record. If there are multiple records then it has to be the last one.

This seems simple, but I can't figure it out.

I've added a sample, with some comments. I hope you guys can find it.

Thx!!

[vgutkovsky]

Try this: firstsortedvalue(StockHis.QtyAfter,-num#(replace(StockKey,Company,'')))

Regards,

Vlad