# Displays unique data in another table, from which data is used for calculations **URL:** \ **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:** 7\ **Page:** 1
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [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/1 "2024-11-19T17:43:20Z")
is there a way to calculate unique dates? I have data entry like this ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/108cee00c54dd9b7233d238165a5d5da1226ced7.png) 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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd605f3365be5df1701e26c0dc174550d00a48ec.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [November 19, 2024, 5:49pm UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/2 "2024-11-19T17:49:23Z")
Try to joined all dates to an array and use Unique Elements column ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 19, 2024, 5:56pm UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/3 "2024-11-19T17:56:44Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98dc39dc5426a2281309691da3ba67072c295a35.png) I have created a joined column, but when adding a unique data element it is not available, is there something wrong? please guide ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [November 19, 2024, 6:00pm UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/4 "2024-11-19T18:00:25Z")
Not joined list, but lookup ---
**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")
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”. ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [November 20, 2024, 11:05am UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/6 "2024-11-20T11:05:02Z")
thank you very much @ThinhDinh , this method works ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 27, 2024, 11:05am UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/7 "2024-11-27T11:05:49Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.