SUM Lastest Data

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

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

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

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

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

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.

1 Like