When I apply Auto Filter in a table and the SUM of any column is calculated, the sum total disappears if the table is filtered with any condition.
Using Excel, I can use Total row here which does not remove the Total
Please upload an ,ods type sample file with the applied Autofilter.