List box to straight table connection

[Anonymous]

Hello all, I have an expression in my list box if(Parindicators2='Y',Networks2)

List Box

North

South

Main

West

in my straight table there is a pivot on Netowrks2 it looks like below

Id     Main        South           North          West

1        Y              Y        

2                                           Y                  Y

3                        Y

Currently when I select North in my list box I would get column North and West.

Is there a way to only see North column when I select North from the list box, etc?

Results I would like to see.

User selects North in list box and straight table results would be:

Id            North

2                Y

Currently I get:

Id         North         West

2            Y               Y

[m_woolf]

Have you tried using the same code if(Parindicators2='Y',Networks2)for the Networks2 dimension in your pivot table?

[Anonymous]

Yes, currently I have the below in my straight table.

=MaxString([North)= 'Y'

[ramoncova06]

what selection does it appear in your selection box ?

I assume that it would be showing  ID 2 and not Networks, right ?

[Anonymous]

List box:

North

South

East

West

Expression:

if(Parindicators2='Y',Networks2)

Parindicators2 = Y

Networks2 = North, South East and West.

Straight table:

Id     North       South      East       West      

1           Y            Y          Y              Y

When I select North from the listbox  all I want to see is my straight table columns and only the North Column

Hope that helps...

[ramoncova06]

what I meant was if you create a current selection box

what do you see

[Anonymous]

It shows the below when I select on North

Current Selections

Network2                       North

Parindicators2                   Y

[ramoncova06]

what is your expression ?

[Anonymous]

      List box:      if(Parindicators2='Y',Networks2)

Straight table: =MaxString([North)= 'Y'

[Peter_Cammaert]

Is it a Pivot table or a Straight table? An single object cannot be both. I guess you're talking about a Pivot table because your Networks2 field values do appear as column headings...