How do you make the rows in a straight table non-selectable

[jimgibson]

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?

[PrashantSangle · Accepted solution]

Hi,

did not get your requirement..

If you want to straight table non-selectable then select read only.

Regards

[#3]

this should be possible by using p or e in your set analysis. Have a look here:

P() & E() and where do you use them?

[#4]

Using "dimension limit", may be just show 99% of the data, then 1% row cannot be selected. Or, use lock field? Hope it works!

[Peter_Cammaert]

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

[antoniotiman]

Hi Jim,

in the original Table You can Use Expression with {1} state, like

Sum({1} Value)

Regards,

Antonio

[tyagishaila]

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)