# Sum Periodic using group **URL:** https://community.glideapps.com/t/sum-periodic-using-group/71153 **Category:** Ask for Help **Created:** [February 26, 2024, 2:40am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153 "2024-02-26T02:40:56Z") **Posts on this page:** 6 **Page:** 1
### Author: ![abba](https://avatars.discourse-cdn.com/v4/letter/a/9f8e36/32.png) [@abba](https://community.glideapps.com/u/abba) #### Post date: [February 26, 2024, 2:40am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/1 "2024-02-26T02:40:56Z")
Hi. i have transaction table which record all transaction. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/798e788eb3f7220f88140e08f580412f3b8aa656.png) i want summarize every year periode column jumlah group by NAMA LHA filtered by tanggal kindly what the best approaches to solve this. Kind Regards, ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [February 26, 2024, 3:19am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/2 "2024-02-26T03:19:39Z")
- Create a math column using the formula `Year(Date)`. Use your Tanggal column as a replacement for Date - Create a Query column that targets the table shown, and apply the following filters: – Nama LHA is This row → Nama LHA – Year (math column) is This row → Year - Create a rollup column that targets the query column, and take a sum of the Jumlah values ---
### Author: ![abba](https://avatars.discourse-cdn.com/v4/letter/a/9f8e36/32.png) [@abba](https://community.glideapps.com/u/abba) #### Post date: [February 26, 2024, 4:26am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/3 "2024-02-26T04:26:08Z")
Hi Darren thanks for your assist, i’m just trying implement that step, is that result is correct? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8178bfec19c55409f3dd976cd45fc577996b51eb.png) if yes, now i want put the total every year (jumlah\_pertahun) show in datagrid as below the data transaction as summaries (line blue) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98c09901c03559a832ba3e348948bb27cfd4166c.png) or any better way to desain that, thanks ---
### 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: [February 27, 2024, 12:14am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/4 "2024-02-27T00:14:15Z")
I don’t think you can do that with a data grid, it is meant to show data coming from a specific table, and unless you have a row in that same table for “total”, it’s not going to work. I would just explore options for creating a HTML table and display it in a rich text component. ---
### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager) #### Post date: [February 27, 2024, 12:42am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/5 "2024-02-27T00:42:34Z")
Another option is to create a Rollup column and then display that rollup value using a separate component below the data grid. Something like this. ![Screenshot_20240226-184108](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6986ff1c9f94254ff5e6543483a069982281a84.png) ---
### Author: ![abba](https://avatars.discourse-cdn.com/v4/letter/a/9f8e36/32.png) [@abba](https://community.glideapps.com/u/abba) #### Post date: [March 1, 2024, 7:20am UTC](https://community.glideapps.com/t/sum-periodic-using-group/71153/6 "2024-03-01T07:20:05Z")
Thanks @ThinhDinh @Jeff_Hager