SOLVED

Pivot table contains filter

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)
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:

DTE_0-1648022174000.png

DTE_1-1648022233354.png

 

Better option would be to use slicers:

DTE_2-1648022299239.png

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

DTE_3-1648022355110.png

DTE_4-1648022374941.png

 

 

 

 

Thank you. Appreciate your solution.