Displays unique data in another table, from which data is used for calculations

Ask for Help
1

is there a way to calculate unique dates?
I have data entry like this

image
image1051Ă—638 49 KB

in another sheet I have data that takes the unique date of the data entry, in the spreadsheet I can do it easily, but what about GT?

image
image629Ă—649 27.3 KB

2

Try to joined all dates to an array and use Unique Elements column

3

image
image748Ă—549 40 KB

I have created a joined column, but when adding a unique data element it is not available, is there something wrong?
please guide

4

Not joined list, but lookup

5

Do you care about what you’re supposed to display not having days when you don’t have any records?

One of the methods would be:

  • Create a query filtering the Tanggal column to be the same as current row > Tanggal and Kode Mutasi equals to 2.
  • Use a rollup to calculate the sum of the column you need.
  • Add a single value column on top of the query to return the first rowID.
  • On the front end, show records from this table with the rollup, filter by rowID equals to “first rowID”.
1 Like
6

thank you very much @ThinhDinh , this method works

1 Like
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.