Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a scenario where i am showing week on week Sales in line chart. I want to change the color of line chart symbol as per the below thing: if current week sales amount is less than prev week sales amount then current week sales symbol should be red..else green. same goes for other weeks, i.e. if prev week sales amount is less than prev to prev week sales amount, then prev week symbol should be red else green.
I am hoping an early reply as this is an urgent requirement.
Thanks
Hi
May be try to use two expression
One with sales< the other> with two different colors
Hi,
You can use PEEK function to get the value of prior week and compare with current week. Then use this in Expression --> Background Color.
Hope this helps.
Thanks
like this?
is this what you want ?
it seems good I didn't think at that