Filtering Data in a Pivot Table - Excel Basics

Suppose, we aggregate data by groups of parameters, say marital—education. Within these groups, can we selectively look at the response rates of only self-employed people i.e. self-employed single and tertiary educated or self-employed divorced and tertiary educated?

Filters allow us to achieve the same.

Can we select multiple parameters in the filters? Absolutely! Let's explore

Slicers present a visual interface to select multiple parameters. Try and use Ctrl to select multiple parameters and observe how the values in the PIVOT Table change automatically.

Are you confused between the use case for slicers and filters?

Slicers should be used when preparing a visual interface. Filters should be used when preparing a report.