Filter - Keeping a Constant Row

[tayto]

Hello, I am creating a spreadsheet to be used by people who are unlikely to use anything but auto-filter.

In this spreadsheet, I have several rows that I want to remain on the view, regardless of the auto-filter selection. Please see my example below.

If column A is filtered for Europe, I still want Global to appear, or if B is filtered for Japan, I still want Global to appear. However, if C is filtered for February, the January Global can disappear.

Is anyone aware of a way to do that that is very user friendly (i.e. it does not require a custom filter)?

Thanks!



A          B        C         D
Europe        Sweden         January         123
Europe         Norway         January         234
Europe         Spain         January         345
Asia         Japan         January         456
South Am.         Argentina         January         678
GLOBAL         -         January         789
Europe         Sweden         February         987
Europe         Norway         February         876
Europe         Spain         February         765
Asia         Japan         February         654
South Am.         Argentina         February         543
GLOBAL         -         February         432