How to stop rows underneath being affected by a filter

Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more rows with the subtotal and grand total in, obviously you dont need to enter anything in this. But whe i filter out the blanks those rows disappear? how i do i stop this please? I have tried everything and desperate for help! Thank you