Dynamic Offset Ranges

I have a large table of data that includes various subsets and updates every month, adding in a new row for each subset.

Is there any way to create a range that will always be defined as belonging to a specific subset?

I am running a number of different measrues of the data, but need them all split by the subsets...

Thanks!