Use Slicers to Filter
the Data
Before You
Begin: Click on the PivotChart.
The
PivotChart Tools should be available.
1.
Try it: Insert Slicers
Go to
PivotChart Tools ->Analyze-> Filter.
Click on
Insert Slicer.

What Do
You See? You will be prompted to select the Fields you want to
include.
Select the
following fields:
Category
Product
Please
click OK.
Keep
going...