Last purchase date and price

[#1]

Hello,

i have a table_chart that looks like this

ItemID(Dimension), Date of purchase(Dimension) - Expression: Amount, QTY. I want to add Last Price and Last purchase Date.

The Line "ItemID" is connected to saleslines and via the Saleslines with the customer table. The values change when i select the buyer for whom i want the statistics.

The Expression: FirstSortedValue( Salesprice , -Date)  should give me the last price and it does. But my problems:

- Some fields(items) have "-" as a value in last price, i think its due to the fact that the Item have been sold on one day more then once?

- last purchase date isnt beeing showed at all

I would appreciate help on this matter.

The table should show every Item only once with the last date and last Price and when i select a customer it should adopt. Anybody an idea how the formula should look like?

Thank you in advance

[er_mohit · Accepted solution]

see the attached file

here it show value of last date

if you want group by then go to script side uncomment field then see the output

[#3]

Ti should always show me the "youngest" value. So when i put the filter "on" for customers, it should show me the one from the customer

[#4]

there is none