1 of 1 people found this helpful
I'm assuming you have to go with the table calc here. things might be easier without table calcs in the mix.
Make another table calc:
WINDOW_MAX(ROA Compare TEST (copy))
Run that calc TABLE(DOWN). Or maybe run it along MONTH(Date). (Still preserve whatever setting you have for the first table calc.)
You should get all 1s in all months. If you can achieve that, then on one sheet filter for the new table calc = 1, and on the other filter for that same table calc = 0.
Working great so far Joe! Thanks!