VBA: How to slect a group of years range under a threshold???

[luckyali]

Dear experts,
I have my data arranged in a pivot table per year from 2000-2020. I display the data under a group of years e.g. 2001-2005 etc. For this purpose I used the slicer item to select that range i.e.

Please Login or Register  to view this content.

This works fine. Now that i want to put a threshold e.g. show all the data below 2010. but at the same time I need to keep the groups as they are. which means keep showing the groups and stop when the threshold reaches or something like that. Any comments or suggestions are most welcomed.

Best Regards
Ali