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

**URL:** <https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027>\
**Category:** Ask for Help\
**Created:** [November 19, 2024, 5:43pm UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027 "2024-11-19T17:43:20Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 20, 2024, 12:51am UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/5 "2024-11-20T00:51:21Z")

</div>

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

---

_[View the full topic](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027)._