I want to know if its possible to restrict the selection of values in the straight table to only one value at a time.
I have a dependency on the value selection and if multiple values are selected the data does not look good. So I want to restrict the selection to only one value at a time.
If possible how can this be done?
Unless it is what Tresesco points out above it could also be under Straight Tables and on the "Dimension Limits" tab. Here you can pick "Restrict Values" and then Show Only -> First/Largest/Smallest -> 1 values (Remember to remove "Show others" lower down.
Beside the suggestion from tresesco which effects the selection from this field global you could use calculation-conditions within this table like: getselectedcount(YourField) = 1. A further possibility might be to adjust your expressions maybe with set analysis.
What I think you can do is in the Straight chart
General Tab -> In Calculation Condition, type below expression.
Then in the Error Messages Select condition unfulfilled then expression will be
=IF(GetSelectedCount(DimensionFieldName)>1 ,'Please select one value at anytime')
This will give user instruction what to do.
Try it and let us know what you think
Hope this helps