Pivot table contains filter

[Naftycs]

Hello:

I want to get the Count of (US, UK) together in the pivot table. I cannot filter (US, UK) count. I have attached the .xls file and tried screenshots for your help.

Thanks

[#2 · Accepted solution]

Hi @Naftycs 

if I understand you correctly, you want to filter both "US, UK" and also "UK, US", right?

Usually, you cannot do this with a normal label filter, because you can enter always only one criteria.

In your specific case you could just filter for the comma:

Better option would be to use slicers:

There you could select multiple values by holding the Ctrl-key:

[#3]

Thank you. Appreciate your solution.