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.
in a sheet or graph
add a calculated dimension :
and then you can access price in expression
View solution in original post
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.
Thanks for replying, but I mean I don't want to change the script. Is there a way to write a function?