Adding a Grand Total to the Columns as a new row

I need the following columns summed up into a new “Grand Total ROW” I thought I could with the math formula, but I am not seeing a SUM function. Any tips? So each column should have a row with all values added up in the 5 rows shown.

image

You can calculate the total using the group by node, and then add it to the bottom of the table using the bottom port of the concatenate node.

Edit - The above was to sum values vertically in the same column, if you want to sum values horizontally that occur in different columns then you can use the Math, Rule Engine, Column Expressions nodes.

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.