1016 Pivot Table - Slicer vs. Report Filter

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$181.15
You save:  A$51.76
List Price:  ৳11,861.64
You save:  ৳3,389.28
List Price:  CA$170.33
You save:  CA$48.67
CHF 90.60
List Price:  CHF 126.84
You save:  CHF 36.24
List Price:  kr861.81
You save:  kr246.24
List Price:  €115.88
You save:  €33.11
List Price:  £99.72
You save:  £28.49
List Price:  HK$1,087.52
You save:  HK$310.74
List Price:  ₹10,286.47
You save:  ₹2,939.20
List Price:  RM577.52
You save:  RM165.02
List Price:  ₦57,205.51
You save:  ₦16,345.60
List Price:  kr1,171.13
You save:  kr334.63
List Price:  NZ$194.85
You save:  NZ$55.67
List Price:  ₱6,699.38
You save:  ₱1,914.24
List Price:  ₨21,313.47
You save:  ₨6,090
List Price:  S$186.68
You save:  S$53.34
List Price:  ฿4,385.46
You save:  ฿1,253.08
List Price:  ₺1,190.66
You save:  ₺340.21
List Price:  B$738.48
You save:  B$211.01
List Price:  R1,975.02
You save:  R564.33
List Price:  Лв226.53
You save:  Лв64.72
List Price:  ₩158,127.20
You save:  ₩45,182.42
List Price:  ₪460.09
You save:  ₪131.46
Already have an account? Log In


Hello and welcome back. This time we talk about slicer. Something which has been introduced new in Excel version 2010. I want to slice up. Technically it is a filtering component, a panel which allows you to filter the list items through a visually appealing dialog box. Let me show you live what is it and where it can be used.

Assume that you are given a task whereby you are putting the division name and the salary in the main action area so as to show the sum of salary. Now, typically what happens I use reports with the pages to use as a master filter so that if I want the division ad data only ad can be chosen. But the problem is, if I put division in the report filter, it gets away from the roof fields list. So in that case, what do people do, they generally go back to the original data, they again copy the entire block of division copy and create another dummy column which is nothing but the same set of items which is division. Now in columns To this, let me show you a trick, especially in the context of slicers. Let me give back the same report to pivot table.

So division by salary. Now this time, I'm going to go to Pivot Table Tools, Options. In 2013 version of Excel, it's called analyze. So once I reach there, there is a button called insert slicer. I'm going to click on that, as I click on that, notice what comes up, you get a list of field list names. So I'm going to choose the same thing which is called divisions.

And if I press OK, you get a very beautifully placed panel on your screen. Now, if you choose ad, notice the data has been displayed with respect to AD and you also have the facility of the name ad being displayed in the pivot table report. This you could not have done so easily without slicer had you not inserted a dummy column your raw original data. And in fact, if you press Ctrl You can also choose some other divisions from the slicer. Additionally, if you click on this panel which says clear filter, everything goes back to normal. Now all the data pertains to to the condition.

Not only that, if you don't want this slicer for any reason, you may right click on this panel and simply say remove division. Why remove division because the slicer has been attached with division fees. So remove division, and then you go back to normal. So this was slicer. Hope you work with slicers specially when you require a dashboard based pivot table

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.