I used "Ship Mode" in this example.
Trying to show two items out of four.
Duplicate the field.
And put both fields to filter shelf.
Then, show filter for "Ship Mode 2"
Change filter mode to "Only relevant value"
When you filter "Ship Mode"
You see only two items out of four in this case.
Once you hide "Ship Mode"
It shows only filtered items.
With "Show Filter" on "Ship Mode", you can see full list.
Table_Calc_SS_SM_10.0.twbx 390.8 KB