Select your Pivot Table Data using Slicers. Learn how to select and work with Slicer selections in Episode #1288. ...This episode is the video companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Pivot Table Data Crunching for 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 going to go to Options, Insert Slicer, Insert Slicer will choose a let's do Region and Market, that'll be good and click OK.
All right! So, you see that we have two sets of slicers here and on the left side, I'm going to choose north and northeast.
So, I click on North drag down to Northeast 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 not really grayed out, but just kind of fade it out are the items that are not even available based on the other selections.
Now I'm going to go through and choose a couple of items.
I'm going to 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.
The items that are white that are not grayed out those are items that would be available.
How do we selected them, but not currently selected.
Now so, it's really easy to go through and choose things that are contiguous 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 one item California and then hold down the Control key, while you go choose the other items that you want and then let go of the Control 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 a frustrating little user interface there.
All right! Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Pivot Table Data Crunching for 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 going to go to Options, Insert Slicer, Insert Slicer will choose a let's do Region and Market, that'll be good and click OK.
All right! So, you see that we have two sets of slicers here and on the left side, I'm going to choose north and northeast.
So, I click on North drag down to Northeast 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 not really grayed out, but just kind of fade it out are the items that are not even available based on the other selections.
Now I'm going to go through and choose a couple of items.
I'm going to 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.
The items that are white that are not grayed out those are items that would be available.
How do we selected them, but not currently selected.
Now so, it's really easy to go through and choose things that are contiguous 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 one item California and then hold down the Control key, while you go choose the other items that you want and then let go of the Control 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 a frustrating little user interface there.
All right! Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
