Get Sum of a Table Column in a Label

Issue

I need to calculate the total of a specific column in a label in my Appsmith application. I am using a table widget with client-side pagination. When I change the page, I want the label to update with the page-wise total dynamically. I also need the label to update when I apply sorting or filters from the client-side.

Resolution

To calculate the total of a specific column in a label for a table with client-side pagination in Appsmith, follow these steps:

For Server-Side Pagination:

You can write a query to calculate the total directly in your database, and use that result in the label.

For Client-Side Pagination:

Use the lodash function sumBy to calculate the total of a specific column from the table data.

Example 1: To Sum the "Visa" Column

Use the following code to sum the "Visa" column across all pages:
```
{{ _.sumBy(table1.data, (row) => row.Visa) }}
```