Specify values for rows / columns + Slicers

What if we only wanted to see counts for students for each Primary Focus from OH, IL, and IN?

To do so, we'd click on the downward-facing arrow by "Column Labels" and select only OH, IL, and IN.

PivotTables enable you to automatically "slice-and-dice" your data, essentially meaning you can filter with ease and visualize insights in an instant.

How to use a Slicer to filter

Slicers enable users of the PivotTable to easily filter without needing to click the downward-facing arrow.

To add one to your PivotTable, simply click the "PivotTable Analyze" tab in our ribbon and select "Insert Slicer". In our case, we'll select State to slice on.

Now, we can easily click which states we want to see in our PivotTable!

Slicers are very similar to filters, they just look better and are easier to use!