1 of 1 people found this helpful
If you use a table calc as a filter, it will leave the underlying table intact, and just display the marks from the table that satisfy the filter.
Consider something like this:
LOOKUP( ( IF [insert whatever logic defines the conditions you want displayed here] THEN 1 else 0 END ) , 0 )
Put that on the filter shelf and select for value=1. Those months will be displayed, but the future months still live in the underlying table to let your forward-looking averages still work.
Thanks a lot Joe!