HomeХобби и стильRelated VideosMore From: Excel Campus - Jon

Setup a Slicer to Sort or Filter Another Slicer for Quick Navigation

1066 ratings | 56325 views
Learn how to group text or number fields to create a slicer that can sort and filter another slicer. This technique is great for slicers that contain a lot of items and are difficult to navigate. You can create a slicer with less items that will help sort and filter the longer slicer. This technique can be used for slicer fields with text (people names, product names, etc.) or numbers (phone numbers, id numbers, account codes, etc.) Download the file and read the article at: http://www.excelcampus.com/pivot-tables/how-to-sort-a-slicer-with-another-slicer/ Subscribe to my free email newsletter: http://www.excelcampus.com/newsletter
Html code for embedding videos on your blog
Text Comments (59)
Mishkafofer (10 days ago)
Love the content and also the pace of delivery and voice control. Surely you have invested in great microphone.
Manish Shukla Channel (30 days ago)
Very useful trick. Thanks for such a nice technique.😀
Ammad Mubashar (1 month ago)
Hello John- Good day! bundles of thanks for sharing the solution of slicer filters. but I am facing the issue in filter pivot table when I click the any sale rep name my filter pivot table is is move to another column. how to fix it. Thanks in advance.
I love puppies (1 month ago)
Very clever, thanks!
Mr Ahmed Elmasry (2 months ago)
thanks; how to extract a selected value from a slicer that deal with a regular"non Pivot" Table to a cell with formula ?
Ben Tenison (2 months ago)
Thanks Jon! I was looking this for month ago.....
sachin kishore (3 months ago)
Angela Garine (3 months ago)
thank you for covering this topic in a very simple way
Luciano (3 months ago)
Essas dicas ajuda bastante, obrigado...
Aloysius Barboza (7 months ago)
Can we create a slicer for the main data sheet for filters
Max Fueloon (9 months ago)
Useful and the applications of this are immense for the imaginative analyst
Saravanan Devarajan (9 months ago)
Slicers are amazing!!! Wondering about that!!! Thanks Jon
Samir G (9 months ago)
Excellent video as usual. Thank you !
Sameh Ramadan (11 months ago)
Excellent. Thank you.
true_de (1 year ago)
Very good tip, that helps to make a report more clearly.
It is possible to create dependent slicers but not just for the first character as this video but rather for actual dependent filters?? For example, instead of first letter and name, for system (1st slicer) and subsystem ( 2nd slicer). I hope you can help me. Thanks.
Teresa Chau (1 year ago)
How to add slicer by Top 5/10/20?
Stewart Young (1 year ago)
Thank You
HellIDunnoIGot90OfEm (1 year ago)
Thanks Jon! This is very helpful. For my report, I created a "Category" field that groups several "Services" - so the Category is the first slicer to shorten the choice of Services. Then I added those field names as "Report Filters" on the pivot table (I'll hide those rows in the final report). By doing this, I can test whether one or the other says "(All)" to see what filters are set. From that I have set my report header formula to reflect the contents of the resulting data, e.g.: Only Category selected: Volumes for the Neuroscience Category during May 2016 - May 2017 vs. A single service selected: Volumes for Adult Neurology Service during May 2016 - May 2017vs. No filters selected, "(All)" on both filters: Total Volume of Requests during May 2016 - May 2017 Hope someone finds this useful as well! Kim
Kevin Lehrbass (1 year ago)
thanks Jon! Slicers are amazing!
Sheldon Boyi (1 year ago)
Thanks so much it was amazing
MEST Pujehun (1 year ago)
Alex Rosén (1 year ago)
Great tutorial. Really helpful. Thank you Jon :-)
Challa Lewis (1 year ago)
Jon just discovered u this week and im in awe.
Oh My God! You are the best! Your videos are so helpful and professional. Thank you.
Putttn (1 year ago)
This is so informative. I'm randomly finding Jon's videos, isn't there a place to find all your videos. I'd gladly enroll in your courses/videos over the ones I've seen offered about excel. Do you offer courses on excel?
Excel Campus - Jon (1 year ago)
Thanks Puttn! You can find all my Youtube videos on the Excel Campus Channel. Here is the link: https://www.youtube.com/channel/UCSxX7Vgyu9iThxPE1jSDFdw I do have online courses as well. Here is the link to those. https://www.excelcampus.com/courses I hope that helps. Thanks again for your support! :-)
Mehdi Hammadi (1 year ago)
Thank you for sharing Jon
Excel Campus - Jon (1 year ago)
Thanks Mehdi! :-)
Tariq Jahangeer (1 year ago)
I created 3 columns data with Slicer (name,address,telephone and 1st initial ) I apply filter command then I have noticed that I there is  1st initial following formula =LEFT([@[name]],1) not matching then I apply =lEFT(nameA2,1) this formula working but more the 6/7 columns =LEFT([@[name]],1) is working but I created as per your formula. when I click slicer chart any name that time some name column width small size / some name columns width are big size are displaying i want to set fixed size kindly help me .......... thanks
Tariq Jahangeer (1 year ago)
Thanks Problem Solved. this function only for Pivot Table or some others data also can apply same
Excel Campus - Jon (1 year ago)
Hi Tariq, Great question. There is a pivot table option that allows you to turn off the auto adjustment of the column widths. Here is an article that explains how to do it. https://blogs.office.com/2012/05/14/quick-trick-resizing-column-widths-in-pivot-tables/ I hope that helps. Thanks!
Tariq Jahangeer (1 year ago)
Thanks for sharing this kind of useful video.......
Jason Koo (2 years ago)
Tx Jon for a simple but useful tips. Wonder if could also advice how would you summaries the value of top X items. My purpose of that is to know if top 10 or top 20 and so on, will meet the target revenue.
RAPHAEL PEREZ (2 years ago)
Thank you Sir Jon for sharing your expertise in Pivot Table and Slicer. Now I know the purpose of these tools. I hope you give more and tricky activities on it. I have learned a lot from your videos and I know now on how to execute these tools.
vsali (2 years ago)
brilliant idea so simple will really make a difference
Jill Kennel (2 years ago)
I saw a statement somewhere that said Slicer acts much like the Page Filter so I couldn't understand why we need Slicer. Your video gives good examples of how it can be used, making the spreadsheet easier to use by those who don't really know Excel and it's features. Good job. Thanks.
Excel Campus - Jon (2 years ago)
Thank you Jill! Slicers make filtering more interactive, and are great for users of your files that are not familiar with the filter drop-down menus. They also make it easier to see the items that are selected when multiple items are selected in the slicer or filter. I hope that helps. Thanks again!
rmdyjoe (2 years ago)
Thanks Jon, I really love this video and all your others.... Just wondering how you would search/sort using two or three letters or search the whole name to match using two or three letters. -Joseph
Jill Kennel (2 years ago)
Look into Advanced Filter
jhiscog (2 years ago)
Works well in table but slicer disappear when activated.
Mg Rajesh (2 years ago)
I learnt more watching your videos...keep it up Jon :)
Excel Campus - Jon (2 years ago)
+Mg Rajesh Thanks Mg!
Sai Mon (2 years ago)
Thank Jon, for sharing your videos...Its really helping me....!!!
Excel Campus - Jon (2 years ago)
+Sai Mon Awesome! Thanks Sai!
Marius Rajuncius (2 years ago)
emperoy8 (2 years ago)
John is awesome
Excel Campus - Jon (2 years ago)
+emperoy8 And so are you! :-)
Marek Zadęcki (2 years ago)
Very useful. Thanks.
Excel Campus - Jon (2 years ago)
+Marek Zadęcki Thanks Marek! I'm happy to hear that. :-)
Michael Muhanda (2 years ago)
Interesting how slicers work in summarizing data.Very helpful information
Wayne Fonville (2 years ago)
Thanks.  This will help a lot with the data I have to analyze.
Excel Campus - Jon (2 years ago)
+Wayne Fonville Sweet! Thanks Wayne!
Robert Lohman (2 years ago)
Excellent tutorial Jon,  thank you
Excel Campus - Jon (2 years ago)
Thanks Robert!
S Debs (2 years ago)
Excel Campus - Jon (2 years ago)
Thanks Samer!
Colin Coles (2 years ago)
Nice simple method to make selection easier.
Excel Campus - Jon (2 years ago)
Thanks Colin! Glad you enjoyed it :-)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.