Sum Periodic using group

[abba]

Hi.
i have transaction table which record all transaction.

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,

[Darren_Murphy]

• 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

[abba]

Hi Darren

thanks for your assist, i’m just trying implement that step, is that result is correct?

if yes, now i want put the total every year (jumlah_pertahun) show in datagrid as below the data transaction as summaries (line blue)

or any better way to desain that, thanks

[ThinhDinh]

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.

[Jeff_Hager]

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.

[abba]

Thanks @ThinhDinh @Jeff_Hager