I have two tables:
A. Meetings
B. Representatives
'Representative' on table A (Meetings) is a 'Link to another record' leading to the items on table B (Representatives).
I have a need to filter the Representatives table so that it'll show stats for a given period only, for example - show only the stats for these periods:
The closest I got was filtering each calculation field separately:
But this is not good enough as
1. It needs to be applied to each calculation field manually
2. The filter cannot be saved to a view
I have also tried filtering the linked record column by using the 'Limit record selection to a view' option, but this doesn't really limit the record selection as expected - a known issue.
What can be done to achieve a periodical filter for the Representatives table?