Jotform Tables: Ability to get the sum of the groups on a new tab

Hi, can this person create a new tab for each of the groups, and then get the correct sum that way?

Hi April,

Unfortunately, this method will not work. Once you click on the Create a New Tab, it will just create a duplicate sheet. If you delete the group, you will notice that all the data has been copied to the new tab. Thus, calculation of the group entries is not possible. Take a look at the screencast below:

I've gone ahead and added this as feature request and forwarded 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.



What if that person used a filter for each option in that field (10UA, etc..) and created a new tab using that filter, and then used the sum feature? I've done this for several forms with no issue. I was just interested in the response from Jotform that this wasn't possible.

Hi April,

When grouping submissions, the Sum will always show the total of all entries. But, you can filter the entries into separate groups or create new tabs using filters for each group. This way, the Sum will reflect only that specific group. It’s easy to summarize, let me show you how:

1. In Tables, go to the Number column.
2. Click on the Three Dots icon button on the column, then click on Add Summary.
3. Finally, click on Sum.

Give it a try and let us know how it goes.