Automation for a SUM of a certain table view

Can you please create the option for this kind of automation?

When table view is X, look in GROUP X and, take the sum of THIS column (numbers, or time) and add it to this ITEM name, in THIS column, on THIS board

Or is there a workaround?