keep all customers ignoring year filter

[wanyunyang]

My data has three columns: Customer, Year, Sales. And I have Customer and sum(Sales) as a straight table, Year as a filter.

I wonder how to keep all customers ignoring the year I choose. For example, if Customer A didn't have sales in 2020, when I select Year=2020, it will disappear from the table, but I want to keep it with 0 as sales.

[Or]

There's probably a 'clean' way to do this, but I've always used:

Sum(Sales)+Sum({< Year= >} 0)