complex slicer

[fb7894]

Let's say I have a data table with 50 rows. Each row of data represents a USA state.

Is it possible to set up a pivot table and use a slicer that looks like this...
- north
- south
- east
- west
- coast

So each state could fall into multiple catagories. Florida, for example, would be classified as "south", "east" and "coast".

Is this doable? thank you!

[Jim Clayton]

Similar to this maybe?

[fb7894]

Thanks for the reply Jim. Your example is actually what I'm trying to avoid. Is there a way to get all 6 buttons you have listed into one single slicer control?

[p45cal]

Yes this is possible, but it depends on how your source data is currently arranged. Can we get a peep at that? A sample workbook would be ideal.

Another question: If you selected say North and East in this slicer, what do you want to see in the results; all counties that are either North or East (perhaps about 3/4 of your states) or those which are both North and East (only about a quarter of your states)?

[p45cal]

You hardly ever say Thank you.

[fb7894]

Thank you. Sorry for the late response. I was out of town and just now am getting a chance to respond.

[fb7894]

Attached is a sample file.

[p45cal]

Ahhh, you're using the Data Model/Power Query. I suspect this question would be better moved to the Excel BI section (http://www.vbaexpress.com/forum/forumdisplay.php?100-Excel-BI).
I'm not up to speed on this yet.

[fb7894]

I'll do that. Thanks!