1 of 1 people found this helpful
You can do this by joining 2 data sets on field [Unit].
Now as per my understanding for the unit west coast anything sold between
Will be considered as sold by Phil collins and after that by jimmy carter. If that is the case you can put a filter as:
create T|F calculated field as
[date/hour]>=opening contract and ([date/hour]<=closing contract or closing contract is null)
Put it on filter shelf and choose TRUE.
Hope this helps.
Thank you very much. I will try to do that.