Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I have an app where I have a Pivot Table that shows 1 dimension by default and 10 more should be able to get activated by using the conditional dimension feature of QV 11.
It works fine when selecting the first extra 5 dimension. However, when I select a 7th dimension to be shown the current selection switches to NOT and shows the not selected ones.
Also, when I select all dimensions at the same time only the default dimension is being shown.
Does anybody know if there are limitations on how many columns can be selected as conditional dimension?
Cheers
Susanne
Then try this
GetSelectedCount(Label1) > 0 and SubStringCount(GetFieldSelections(Label1, ', ', 20),'Type') >= 1
Use the third argument to increase the number of selections showed
=GetFieldSelections(_Dimension, ',', 20)
UPDATE: Also, look here
Hmm..
when I use it with the way you describe then now all columns are visible as soon as I select only 1 dimension. My conditional formula is:
GetSelectedCount(Label1)>0 and GetFieldSelections(Label1,',',Type',20)>=1
What was your expression previously (before making any changes I suggested)?
GetSelectedCount(Label1)>0 and SubStringCount((GetFieldSelections(Label1),Type')>=1
Then try this
GetSelectedCount(Label1) > 0 and SubStringCount(GetFieldSelections(Label1, ', ', 20),'Type') >= 1
YOU ROCK!! THANKS!!!!