1st table based on 1st selection, 2nd Table on 2nd Selection

[tinkerz1]

Hi,

If I have an list box with 2 records in it and I click on one, I then what the first table on the sheet to have that first selection in an expression.

So if the list box has 2 selections and both selections have been selected then 2 table would be split by the 2nd selections in the list.

=

if(subfield(concat(distinct [Business Function],','),',',1)='Market',1,0)

But I can't get 'Market' to be a flexible statement

Here is my example

Field

A < A is selected

B

Table 1                    Table 2

Filtered By A           Blank

Field

A < A is selected

B < B is selected

Table 1                    Table 2

Filtered By A           Filtered By B

Field

A

B < B is selected

Table 1                    Table 2

Filtered By B           Blank

[maxgro]

see attachment

[miguelbraga]

Maybe you can have something like this:

1st make two variables like this:

vSelectedA with the expression like if(field='A', 1, 0)

vSelectedB with the expression like if(field='B', 1, 0)

2nd in your Table1 check the Show Conditional and add something like this:

=$(vSelectedA) = 1

3rd in your Table2 check the Show Conditional and add something like this:

=$(vSelectedB) = 1

This should do the trick...

Regards,

MB

[tinkerz1]

  When I place this in the caption, it reads the same but wont trigger, it works for index position 1

=

PurgeChar(subfield(GetFieldSelections([Issue - Business Function]),', ',2),' ')&'-'&PurgeChar(subfield(concat(distinct [Issue - Business Function],';'),';',2),' ')

[tinkerz1]

my expression is an if statment

if([Month End Date]-[Created Date]>=365,'Yes','No')

How can this be written into an set expression?