Selecting data from slicers.
Transcript of the video:
MrExcel podcast is sponsored by Excel-XL.
Pivot Table Data Crunching 4: Slicer Selections.
Oh hey, welcome back to the MrExcel netcast.
We're working through the Pivot Table Data Crunching book, here in Chapter 4, we're talking about Slicers.
Just want to talk, a little bit about how these slicers work?
Being able to select values, it drove me crazy at first. I didn't get it, so, I'm gonna go to Options, Insert Slicer, Insert Slicer.
We'll choose a, let's do Region and Market, that'll be good, click OK, all right, so, you see that we have two sets of slicers here and on the left side, I'm gonna choose, North and Northeast, so, I click on North, drag down to North East and that selects both of those.
Now interesting colors here, the items that are in full color, are available in the North and Northeast, so, Baltimore, Buffalo, Dakotas, Great Lakes and New England are the markets that are in the selected regions, if, I would select different regions, then we have different markets, that are available.
Okay and then, the things that are sort of, [ ] great out but just kind of faded out, are the items that are not even available based on the other selections.
Now I'm gonna go through and choose a couple of items.
I'm gonna choose Seattle and Baltimore.
All right so, now you have a couple of interesting color combinations here.
The items that are white and grayed out means that they're un-selected and there's nothing based on the other slicer things, over here, the items that are full color means that they are selected and we do have some hits based on the other slicers.
The faded out color means it is selected, but again, no hits because of the grayed out.
How the items that are white that are not grayed out, those are items that would be available.
How do we selected them?
but are not currently selected, now, so it's really easy to go through and choose things that are contiguous, you just click and drag and release.
All right so, that is really easy but that's never what, I want to do because face it, there are things you want to filter to, how often are they, are they alphabetically next to each other, just never happen, so now, what you can do is?
You can choose 1 item: California and then hold down the Ctrl key, while you go, choose the other items that you want and then let go off the Ctrl key.
All right so, a little tough there to select those.
I always wanted, I frankly think, it should be a multi-select, where I should be able to come in and click on Seattle, click on Buffalo and have them both selected but unfortunately, it just doesn't work like that, it toggles from one to the other, kind of frustrating, little user interface there...
Right hey, I want to thank you for stopping by. I'll see you next time for another netcast from MrExcel.
Pivot Table Data Crunching 4: Slicer Selections.
Oh hey, welcome back to the MrExcel netcast.
We're working through the Pivot Table Data Crunching book, here in Chapter 4, we're talking about Slicers.
Just want to talk, a little bit about how these slicers work?
Being able to select values, it drove me crazy at first. I didn't get it, so, I'm gonna go to Options, Insert Slicer, Insert Slicer.
We'll choose a, let's do Region and Market, that'll be good, click OK, all right, so, you see that we have two sets of slicers here and on the left side, I'm gonna choose, North and Northeast, so, I click on North, drag down to North East and that selects both of those.
Now interesting colors here, the items that are in full color, are available in the North and Northeast, so, Baltimore, Buffalo, Dakotas, Great Lakes and New England are the markets that are in the selected regions, if, I would select different regions, then we have different markets, that are available.
Okay and then, the things that are sort of, [ ] great out but just kind of faded out, are the items that are not even available based on the other selections.
Now I'm gonna go through and choose a couple of items.
I'm gonna choose Seattle and Baltimore.
All right so, now you have a couple of interesting color combinations here.
The items that are white and grayed out means that they're un-selected and there's nothing based on the other slicer things, over here, the items that are full color means that they are selected and we do have some hits based on the other slicers.
The faded out color means it is selected, but again, no hits because of the grayed out.
How the items that are white that are not grayed out, those are items that would be available.
How do we selected them?
but are not currently selected, now, so it's really easy to go through and choose things that are contiguous, you just click and drag and release.
All right so, that is really easy but that's never what, I want to do because face it, there are things you want to filter to, how often are they, are they alphabetically next to each other, just never happen, so now, what you can do is?
You can choose 1 item: California and then hold down the Ctrl key, while you go, choose the other items that you want and then let go off the Ctrl key.
All right so, a little tough there to select those.
I always wanted, I frankly think, it should be a multi-select, where I should be able to come in and click on Seattle, click on Buffalo and have them both selected but unfortunately, it just doesn't work like that, it toggles from one to the other, kind of frustrating, little user interface there...
Right hey, I want to thank you for stopping by. I'll see you next time for another netcast from MrExcel.
