Could you please tell me how to make a sum row on a table with two lines, one with all the table data, regardless of the filter settings, and the other with only the filtered rows?
On the data, keep the aggregation fine, meaning keep the calculated field calculated and not the sum or average.
Ensure that these lines are sticky as well.
Something like that:
Hey @R_S_I_F,
I don't think there is current functionality for this.
A workaround I can think of, is having another table right below your table, that is hidden when no filters are applied, and that shows when filters are applied. This table is simply the sum of all the table data.
As such, you could have your first table with a summary row on the bottom, which would update as you filter. And then you have a table below it, (maybe removing margins so that they are stuck togegher) that appears only when first table has filters applied and it contains the overall totals.
thanks, @MiguelOrtiz for your response
it would not be user-friendly...
Can I add two extra lines for the table with calculated fields that will be used for aggregation and make them sticky?
Any update on that?
Hey @R_S_I_F - thanks for reaching out. I think @MiguelOrtiz's suggestion is probably the best way to implement this currently. I recognize that it might not be the optimal user experience but the alternative (the built-in "Summary row") is fairly inflexible in its current state.
I'll talk to our dev team about potentially expanding the feature-set and overall extensibility of the "Summary Row". 
