Get sum of a table column in a label

I have a table data in my Appsmith application and I need to calculate the total of specific column in a label

Hello, if you are using server-side pagination, you can write a query to do this. If you are using client side pagination, you can use the lodash sumBy function to sum the data
{{ _.sumBy(Table1.tableData, (row) => row.columnName) }}

Thanks Nikhil for your reply
Really I don’t know more about pagination
I only connected a SQL server database to my application and show its data inside a table as shown on the attached photo

I need to sum the value for Cash and the value for the VISA on the labels under the table
I hope you can help me with this

This should work
{{ _.sumBy(Table1.tableData, (row) => row.Visa) }}

I did it but it show empty label

Can you share a screenshot of the query result that you use to populate the Table widget? Is the name of the field returned by your query exactly “Visa”?