Filter data on criteria that can change month to month
I'm fairly new to Anaplan and I'm sure if I'm approaching this issue correctly so I thought I'd ask here.
We have sales rep data that shows what "compensation group" they belong to for a specific month, along with what they sold and earned in that month. I'm trying to create a FYTD report on this that shows each compensation group by rep by month. In trying to make this work I've noticed I have to create an Any filter that checks for each month of the year along with the applicable group(i.e. "Group A and July '21" OR "Group A and August '21" etc.). Is there a better way to filter this?