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

Ask for Help
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