SUM Lastest Data

[dwi_bintang]

HALLO ALL,

I want to sum data in the [SKU] column with a data filter based on input data [NAMA_MDS] column and the last data if [KODE_CUS_GT] has duplicated data, can anyone help me?

SUM(
SELECT(MERCH[SKU],
AND(
[KODE_MDS] = LOOKUP([_THISROW].[NAMA_MDS], “USER”, “USERNAME”, “USER ID”),
[MONTH([TANGGAL]) = MONTH(TODAY()),
(formula to get last data)
)
)
)