Link two tables with chart function

[wanyunyang]

My table1 has field: item, table2 has fields: itemcode, price. In my chart, I want do have a table with item and price. So I need a function like: IF(item=itemcode, price).

Is it possible to do so? I don't want to link two tables in the script, just write chart functions.

[imhappiee]

Hi

Just rename your itemcode as item in the script in Table2 , It will automatically give you the desired result , you dont need to join the tables in specific.

Anand

[wanyunyang]

Hi,

Thanks for replying, but I mean I don't want to change the script. Is there a way to write a function? 

[ogautier62 · Accepted solution]

Hi,

in a sheet or graph

add a calculated dimension :

if(itemcode=item,itemcode)

and then you can access price in expression

regards