(1) Logically, the x associated to the prod(x)_start and prod(x)_end will always be the same. I wanted to use Filter(x) in order to have just one filter pane for this but it does not work. Is there another work around?
(2) I am receiving lines where both "prod" fields are completely NULL or empty. If both of these fields are NULL or empty I do not want to show results. I have tried using a len(trim()) within my pick(match()) clause with no luck. Any solution for this?
I appreciate this is a very wordy question, but I attempted to trawl through forums to no avail!