Pivot Table Slicer
In our last blog post we have seen how we can create Pivot Table in Excel . If you have not yet aware of how to create Pivot Table in Excel you can click here and then continue reading this post. Let’s assume we are creating Pivot Table for data as shown in below image. Slicers are very effective while creating dashboards in excel. We can say that Slicers are “Pictorial Filters”. While we are creating Pivot Table, we are getting 04 Pivot Table areas as shown in below image. Slicers are related to “Filters” area. Let’s create Pivot Table to summarize regional sales data. 1. Drag “Region” field into “Rows” area 2. Drag “Total Sales INR” field into “Values” area 3. Drag “Year” field into “Filters” area. This will create Pivot Table into as shown in below image. One important thing to note here is that filter is now created for field ‘”Year”. If we want to change our summary for any specific year then we can select respective year in that filter. For example, If want...