Pivot Tables

[ThinhDinh]

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

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”.

A variation of this would be applicable to you.

Basically you rollup on top of the relations to same-category items, and then find the first rowID from that same-category list to filter and only show that on the front end (so there are no duplicates).