Show only one occurrence of amount in latest month

[Jox]

Hello dev gurus

Can someone please help?

In this table I am trying to only display one Amount per Number, but to show the Amount always on the most recent month? I tried to use firstsortedvalue() but I just can't seem to get it to work.

Date	Number	Amount
20231	TI_50136703	17,210
20232	TI_50136703	17,210
20231	TI_50146031	18,055
20232	TI_50146031	18,055
20233	TI_50146031	18,055

[Or]

Assuming these are all fields, you would have Number as your dimension and FirstSortedValue(Amount,-Date) as your measure.