Question

TO KNOW ABOUT WHICH FILTERING CRITERIA IS APPLIED

Answer 1

Answer:

3 Ways to Display the Filter Criteria on the Worksheet

Select any cell in the pivot table.

Select the Analyze/Options tab in the ribbon.

Click the Insert Slicer button.

Check the box for the field that is in the Filters area with the filter applied to it.