Filter Pane with constraints

[MikeJones]

Hi, I have the following data which has planned employer and actual employer for each job.  I wish to create a filter pane that when I choose:

• Direct, jobs 1,2,3 and 7 would appear in my table.
• A, jobs 2 and 3 would appear.
• B, jobs 4,5 and 6 would show.
• C, jobs 4,6,7 and 8 would appear.

Jobid	Planned Employer	Actual employer
1	Direct	Direct
2	Direct	A
3	A	Direct
4	B	C
5	B	B
6	C	B
7	C	Direct
8	C	C

[marcus_sommer]

Both fields have the same data and should be therefore merged per concatenation into a single field, for example with something like:

t: load Jobid, [Planned Employer] = [Actual Employer] as Flag,
           [Planned Employer] as [Employer], 'Planned' as Source
   from Source;
   concatenate(t) load Jobid, [Planned Employer] = [Actual Employer] as Flag,
           [Actual Employer] as [Employer], 'Actual' as Source
   from Source;

and with the extra field Source you could differentiate between planned and actual.