Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Greetimg for the day,
can any one send me expression attributes in a chart expression.
Thanks,
Venkat
Venkat,
Edit color with:
=if(condition=1, RGB(255,0,0), RGB(0,255,0))
Edit line type with:
='<s2>'
decide if show values with:
=if(condition=1, 1,0)
Hope it helps.
Marc.
Hi Venkat,
can you try to be a bit more precise? What exactly do you want to do?
The expression attributes are on the "formulas" tab, when you click on the little + to expand.
There is something about them in the help_file, though it's not too much.
Best regards,
DataNibbler
Hi DATANIBBLER,
i need to give colors to my pivot tables cells diffrent colors for each row based on dimension
can you help me on this .
Venkat
Hi,
I don't do much work with pivot_tables - but I guess it works like it does in any other type of chart:
You have to expand as I said, click into the edit_field for "background_colour" and enter an IF_formula there, depending on your dimension - so it would be sth like
>> = IF([dimension] = 'X', BLUE(), RED()) <<
HTH
Best regards,
DataNibbler