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!
