Dynamic Data

[agung_Taufik]

Hi all
is there a way for “TOTAL PEMBELIAN” to be dynamic when I filter the data

[Jeff_Hager]

How are you filtering the data? Essentially, you need to have the logic in your table, so you end up with an IF column that return only the filtered values. Then you can SUM that IF column.

[agung_Taufik]

@Jeff_Hager

How are you filtering the data?

I filter data by date, when I filter a specific date, I want “HARGA PRODUCT” to change the number dynamically.

[Darren_Murphy]

It’s not possible to do this with the native filter, so as Jeff suggested you will need to build your own custom filter with associated logic in the data editor.

There are plenty of tutorials and guides around that show you how to do this. Search for “dynamic filter”