Field Index

[#1]

I have a table like this. I have to get the first product from the table using FieldIndex. i.e. I have to show chart for each product seperately for different month. I can't hard code it and use calculated dimension as " if(Product='Product 1', Product) " as my chart has to be dynamic so that even if the product name changes it works. So is there a function which identifies the product present in the Product column. FieldIndex is one but i am not able to use it as i don't know its syntax. Any suggestion ?? 

Thanks in Advance

Product	VolumeM1	VolumeM2	VolumeM3	VolumeM4	VolumeM5
Product 1	10	12	13	10	8
Product 2	15	5	6	9	12
Product 3	8	5	9	7	9
Product 4	12	9	8	12	11
Product 5	6	8	14	12	14

[swuehl · Accepted solution]

If you don't know the syntax, just look it up in the Help file (F1 is your little helper for that). I think you need to look for fieldvalue() instead of fieldindex(), since the value of the field is what you are interested in, right?

I believe it will look like

=if(Product=FieldValue('Product',1),Product)

[lironbaram]

please check attach file

hope it gives you any help

[#4]

Thanks Swuehi.. It works

[#5]

Thanks for  your help Liron