Hello all, I have an expression in my list box if(Parindicators2='Y',Networks2)
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
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:
Currently I get:
Id North West
2 Y Y
Parindicators2 = Y
Networks2 = North, South East and West.
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...