Hi,
First:
Load * Inline [
Month,Value
Jan, 10
Feb, 15
Mar, 20
Apr, 30
May, 20
Jun, 20
Jul, 20
Aug, 20
Sep, 20
Oct, 20
Nov, 20
Dec, 20
];
Second:
Load * Inline [
Month,Value2
Jan, 10
Feb, 20
Mar, 30
];
I am using line chart with two expression. When I use accumulation(or rangesum), the graph is saturated after March month for second expression(sum(Value2). I want to hide the values in the graph. I tried changing the background color and text color, it didnt work. It was working with Straight Table and Bar chart. I have one problem in Line chart, the graph displays till April Month.
For second Expression:
Background color : if(Column(2) =above(sum(Column(1))),White(),green())
Text color : if(Column(2) =above(sum(Column(1))),White(),green())
How to hide the repeated values?
Thanks
What about doing the check for value already in the expression:
=If(Len(trim(Value2)),Rangesum(Above(Sum(Value2),0,rowno())))
What about doing the check for value already in the expression:
=If(Len(trim(Value2)),Rangesum(Above(Sum(Value2),0,rowno())))
Thanks Swuehl. Its working now. .
I used rank function in Background color. if(isnum(rank(below(sum(value2))),white(),green())