use of only in a table

[samuel_brierley]

Hi all,

I have 2 tables and in both theres a speed function, they have different names and are kept separate on purpose.

anyway what I want to do is use an only function on the dimension speed to return a value from another table, hopefully my example will mmake this clearer.

only({$< [Average Speed] = {'85'}>} Value)

85 isn't a value I put in its the value of the average speed dimension where the formula sits.

thanks for any help.

[sunny_talwar]

Since these two tables are not connected, your set analysis statement won't make any difference. What exactly are your trying to do?

[giakoum]

not very clear, but it seems that you are trying to have set analysis on row level, which is not directly possible. Set analysis works on chart level. But a sample app would help.