Hello, my goal is to navigate selections by making sure that, if I select certain values from field1, they are reflected in the field2, erasing the selection from the field 1.
Let me explain with an example:
This is my table
Dim1 | Dim2 | Dim3 |
---|
A | a | X |
A | a | Y |
A | a | Z |
A | b | X |
A | b | Y |
A | b | Z |
B | c | X |
B | c | Y |
B | c | Z |
B | d | X |
B | d | Y |
B | d | Z |
C | e | X |
C | e | Y |
C | e | Z |
C | f | X |
C | f | Y |
C | f | Z |
Now, I select value B from Dim1
Dim1 | Dim2 | Dim3 |
---|
B | c | X |
B | c | Y |
B | c | Z |
B | d | X |
B | d | Y |
B | d | Z |
Now I want that Dim2 is filtered by the value I selected in Dim1, in this way:
Dim1 | Dim2 | Dim3 |
---|
A | b | X |
A | b | Y |
A | b | Z |
Up to here it works using a button and a variable.
I created a variable: variabile1=GetFieldSelections( Dim1).
The button has three actions:
Select in field --> Dim2=variabile1
Clear field --> Dim1
Clear field --> Dim2
You can see my example attached.
1. Is there a way to do this without a button?
2. If I select multiple value from Dim1, my button doesn't work. Any idea?
Thanks!