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?