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)
)
)
)

[hru]

You might need to provide the complete table structure, and clarify:

• if the snapshot is the MERCH table?
• Where is the [KODE_MDS]?

[dwi_bintang]

There must be a [KODE_MDS] column on the left [NAME_MDS], but both are the same object

[hru]

Sorry, but I still don’t understand. Maybe if you change the expression to match the column name, example is below:

and based on the snapshot, I could not see any duplicated value for the [KODE_CUS_GT], I might be wrong, but it seems they are unique.

dwi.bintang:

[KODE_CUS_GT] has duplicated data