How to make the 'Total's' row automatically move up and down as list grows and shrinks?

Hello - really sorry I can't - it's sensitive data to the company.

But it really is a simple question. You have a list that's based on a drop-down menu. The list displays 'blue' animals or 'red' animals based on that drop-down menu.

If you select 'blue', the list is long (because there are many blue animals and the list will now only display the many blue animals), but if you select 'red' - that same list is short (because there are few red animals and that same list will now only display the few red animals).

However, I need the totals row to always be one row below the bottom row of the list - whether that list is only blue animals or only red animals.

At the moment, when you select 'red', the totals row appears one below the last row for BLUE animals - which is a long way down from the last row for the RED animals as there are far fewer red animals than blue animals (and, of course, each animal occupies one row of the spreadsheet). So a big gap is left. I need the totals row to move up and down depending on how long the list is - not stay in one place as the list changes length.