Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have an issue with Current selection box.
The issue is : i have one stright table and that related values also available in other sheet also.
So i select one value in stright table in other sheet the current selections shwng as two selected values?
how to overcome this?
Thanks in advance
suresh
Hi fatoux,
thnks for u.stdng the issue
Is there any option to ovrcome this? please help me out?
You could not only authorised the selection in dimensions of a table, but you could unauthorized selection globaly on the table (Table properties --> General --> Read Only).
I don't know if its what you want?
Or you could remove the dimension "prj_id" and add a new measure Only(prj_id) and finally moved it manually before "Project1".
You will have only one dimension that could be selected
thnks for reply....
wen i chk read only.
it is not allowng to select anythng in table?
Yes, that's exactly what I said, that's why I did not think that this solution will go for you.
Have you try my second solution?
yes fatoux....its wrkng fyn..... but wen i add measure as only(prj_id) in stright table its shwng values as null symbol like "-" ?
hmmm yes exctly...............
Strange that signify that they are multiple value for "prj_id", for one "Project1". Only the return the value if unique or Null instead.
Is it true?
how to get that values instead of nulls?
try to do the opposite:
Remove the dimension "Project1" and add a new measure Only(Project1) and finally moved it manually before "prj_id".