Pivot Table-Slicers Auto Multiselect

[Matsuda]

I have certain data in a pivot table, it relates to sales for different months. One filter is set to sales code where I only need to display lets say code 100-110 out of all codes. The issue comes here, Say Jan had 100,102,103 only out of the desired range and Feb had 100,101,102,103, when I switch to Feb I have to manually select 101. Is there a way to define the desired range i.e. 100-110 such that I don't always have to manually select when the month changes?

 

[mart37]

You can use a label filter.

 

[Matsuda]

You can use a label filter.

Mind doing a short demo workbook + tutorial?

 

[mart37]

Filter button for field CODE --> Label Filter --> Between --> 100 - 110