Why the lull, you may ask? Well, it wasn’t until Excel 2013 that tables received this functionality! As nice as it would have been to have them in the 2010 release, it didn’t quite make it. If you noticed, most of those links are dated around late 2010. These tools have grown in popularity and are an outstanding improvement to the product. So you should know that slicers are an effective way to visually filter your data on a PivotTable, and cue you in to what is now visible and what isn’t. Here is some background information to bring you up to speed. What are slicers you ask? If you don’t know, well, you’re in for a treat.

I am getting an inaccurate result because for the Restaurant Type field a restaurant can only be characterized with one option but the restaurant appears multiple times in the data set since a restaurant can be characterized multiple ways for other fields.Slicers were introduced in Excel 2010 for PivotTables.

This is an inaccurate count since the total number of Fast Food Restaurant Type should be 1 and the total number of Diner Restaurant Type should be 1. However, if I create pivot table to summarize the count by restaurant type I'll get an inaccurate result. If I create a pivot table to count the number of restaurants by each dining style I'll get an accurate result since the Dining Style field is multi-select. You'll see here that Bob's Burgers and Fast Burger appear twice since they each have Dine-in and a Take Out Dining Style options. Org ID Org Name Dining Style Restaurant Type As a result when I export data two lines are created per record. a restaurant can have both dine-in and take-out dining options). I have a data set where some fields have more than one value per record (i.e.

Excel 2013 create pivot table options