Refer To Another Expression In Chart

[rebelfox]

I have created a chart 'straight table' with a few expressions.

Is there a way I can refer to the first expression on the chart in the second expression for the same row?

Thanks

[swuehl]

Either use the expression label:

=if(LABEL = .....

or the column() function

=if(column(1) = ....

[sunny_talwar]

You can use Column() function. In your case since you want to refer to the first expression you can use Column(1) in your second expression.

HTH

Best,

Sunny

[sunny_talwar]

Look at the attached sample, it might help you understand better: