Hi,
In my data file, there were three columns: Month, Value and Type. Type can be either 'A' or 'B', and those two types of data need to be showed in one single continuous line. In this chart, I want to mark 'A' in one color and 'B' in a different color.
the expression is =sum({1<Type={'A','B'}, Month= >}Value)
and I put =if(Type='A', red(), green()) in the background color
The color does not change.
Can someone please help me with that?
Thanks,
sophie
