Tables: Provide the Sum of a Column by group

I have used the "Group By" feature to create a new tab in my Submission Tables. In that new tab, I want to be able to Sum the columns of each group... not all groups together. See screenshot below of what I am hoping to achieve.

Hi juniorseahawkshockey,

Thanks for reaching out to Jotform Support. In Jotform Tables, you can use the Group By feature to group entries by answers, which creates separate tabs for each group. But, the sum function available through the Add Summary option calculates the sum for the entire column across all groups, not individually per group.

While the feature you're looking for isn't available at Jotform right now, we've gone ahead and escalated your request to our developers. Exactly when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.



Thanks for the reply. Is there any other way to get the calculations I am looking for without exporting to an Excel spreadsheet and doing it there?

Hi juniorseahawkshockey,

Unfortunately, there is no workaround available at this time. My colleague already submitted a feature request.

Let us know if you need any more help.

Hi craddock,

I answered your other question on a new thread. You can go ahead and check that out here. 

Reach out again if you need any other help.