Excel Table Formatting

I want the data generated to be in a table, then a total at the end outside of the table formatting.

So far, the only way I was able to get the table formatting to cover all the generated data was to apply the table to every cell row within the cell columns.

image

as opposed to just have it on the cell with the data bands only like this:
image

If I make the total get generated within the table styling like the first image, when i try to use the excel table filtering, the total is being filtered as well and i don’t think the user would want that.

Is there a way to go about doing this?