Use of filters

I have a list of data with amounts of money for each row. There is an autosum Total at the bottom of the amounts column. There is more data several rows below the Total cell. I use filtering in this way quite regularly to get a sub-total on different items within the list. On this occasion the filter is filtering out the Total row at the bottom so it doesn't show and also some of the data below it.