Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with 4 columns. I would like to choose one of the rows in the table and have the value in one of the columns be used in expressions and graphs on another sheet. The problem is, the users do not want all the rows in the original straight table to disappear. Anyone know of a way to do that?
Hi,
did not get your requirement..
If you want to straight table non-selectable then select read only.
Regards
Hi,
did not get your requirement..
If you want to straight table non-selectable then select read only.
Regards
this should be possible by using p or e in your set analysis. Have a look here:
Using "dimension limit", may be just show 99% of the data, then 1% row cannot be selected. Or, use lock field? Hope it works!
You want to make selections, and ... not make selections at the same time?
You could accomplish something like that with a selectable copy of your original table that lives in an alternate state together with all the objects on that other sheet.
Peter
Hi Jim,
in the original Table You can Use Expression with {1} state, like
Sum({1} Value)
Regards,
Antonio
Hi Jim,
Your problem is not exactly clear to me,
But as I understood,
Write all dimensions clear into your expression.
e.g.
Dimension: Dim1, Dim2, Dim3
Expression: Sum({< Dim1=, Dim2=, Dim3= >}Sales)