Sum in tables

I need to create a row by the end of each table to calculate a sum of the column values at the end.

Please check the sample

0 7 475
  • UX
7 REPLIES 7

Hi Yasin,

I think you can use below formula to get the sum of the column.

SUM(Classes[Seat Count])` : The sum of all values in the Seat Count column of the Classes table.

Refer this link: https://help.appsheet.com/en/articles/2357307-sum

But I need a row in the end of the table to show this, so how Can I achieve this ?

Itโ€™s not possible to have a summation row in a table without a very complex setup.

@Steve what do you think?

Hi Koichi,

I need help on doing a total like the sample you have posted here. However, the sample is no longer available in this link. Can u help to share again? Will help me tremendously. Thanks.

The easiest way to create this kind of functionalityโ€ฆ add a simple text column to your table and use initial value โ€œTOTALโ€. Then group this table view with that column and aggregate the view with that same column. Then it will show the total likeโ€ฆ TOTAL (318). Though itโ€™s not in the end.

Top Labels in this Space