Group Total without Total of ALL groups totals

As a Builder, I would like to enable the sub-grouping sums option on a table, but to have an option to not include the sums (totals) of all of these sub-grouping sums.

Scenario: I have tables that are grouped by Product. I want to see the total of various columns in the subgroups (Quantity Imported, Quantity Sold and Quantity at Hand) of which there are various batch numbers, but having ALL the subgroup total Quantities summed up is NOT desired as the groupings are not same products!

Try to add something like this to your javascript section:

$(document).on('knack-scene-render.scene_11', function(event, view, data) {
$('#view_222 tbody tr:last-child').css('display', 'none');
});

Where view_222 contains the table. It will find the last row, and hide it.

Depending on your implementation, you could use the CSS section to do this in a simpler way.

1 Like

I will be grateful if you can help guide me on this solution.

Thanks

Just a thought Oludare, as an interim solution until your suggest feature is implemented, you can use CSS to hide this last line, so it want appear on screen.

Nir