Excel Slicer Contains vs Filter

from what i understood you want to be able to select multiple regions in Region Slicer.
to do that, simply hold your keyboard Control Key and then select one by one the regions you want the selection done.
remember clicking twice will deselect it while Control key is pressed.

If you open the workbook, the region slicer is not clean. I want it to show East, West, North, and South. Currently, it is not clean. I am trying to figure out a way to display a clean region and when selected show any items containing that region.

Make sense?

I offered the search box and they do not want it.

Then you would need to add another helper column to split regions. Please refer below link:
Excel Slicer Comma Separated Values

Hi Shums - I was trying to figure out how that would look with the data. I am assuming it would add rows. For example, if there were 3 regions, there would be 2 additional rows (original +2)

if your data is like this , how would you get South when no single value has South. it has South East not "South"

East, West, North
South, East
North, West
North
South, East
East
North

Thats what I am trying to figure out. Right now users can select multiple regions creating entries like south, east. when they filter i need them to be able to pull up any records containing their selection. For example, if you filter on North you should see the following records displayed in the pivot table:

East, West, North
North, West
North
North

No comment has been added to this question in more than 14 days, so it is now classified as abandoned.

If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.