I'm trying to create a table where when i select a value from dimension, one table should be visible.
In the attached Example, when i select a value from W1 list, only W1 table values should be visible.
similarly, when W2 list is selected, only W2 table values should be visible even though there is interlink.
I have a question here...
Its working but, when i select W1, W2 gets cleared and When i select W2, W1 gets cleared.
Can't i make them individual, where i can select W1 and W2 at once with its values populated in its own tables???
If i select 'A' in W1....
It should show the associated values in W1 table.
along with the corresponding values of 'A' in w2.
I have uses Pick(Match(...)
But not working.