Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Help pls.
GetSelectedCount(W2) count the selected so if you don't select W2, W2 table doesn't show
Trying to understand better here -> Both the tables should not be visible until you make a selection in W1 or W2?? As soon as you select one of the other, one of them should become visible?
I think
you can use the GetSelectedCount or GetPossibleCount functions in layout tab of the chart (show conditional)
Hi Sunny,
If i select one i.e.W1. only W1 table should show data...
W2 table should still be there with no data.
Hi Massimo,
I tried but as there are common fields W1, W2 are same.
Its pulling data in second table too.
GetSelectedCount(W2) count the selected so if you don't select W2, W2 table doesn't show
Thanq massimo.
i used set analysis which is working too, but Get selectedcount() showing good performance.
Thanks again.
Hi Massimo,
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???
when you select W1 listbox (and don't select in W2 listbox) you want
show W1 table
don't show W2 table
or
show W1
show W2
?
Massimo,
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.