Google Sheet use filters to sort with Unique

Question

In google sheet, I have a data set A:

In another sheet I am creating a dynamic list using the UNIQUE formula:

However, when I use filters to sort the data, it gets all scattered leaving empty cells where there shouldn't be any:

Does anyone know a workaround to avoid this? Is it impossible to use filters AND Unique at the same time or is there another way to do this?

Answer 1

Use a pivot table, and sort it by sumof column2 instead of the unique + sumif combination that you are using. See this spreadsheet to see it working on your data.