Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have developed a line graph where I plot the Running Sales & Target for the month for each day. So as u progress the month; the chart shows an increasing sales vs target lines.
The formula for sales is as below:
RangeSum(Above(Sum(Sales)),0, RowNo(TOTAL)))
The graph was perfect.
The user comes with a requirement that he need to show sales with green color and the target with blue color. So I tried to develop the graph using value list. Value list dont bring the right graph. I observe that the RangeSum function in not working properly in the value list.
Any suggestions?
Hi..Adnan,
Write this type "if(Year='2014',Red(),Green())" of syntax in expression.
Regard's
Sarvesh Srivastava
or try this
sum(Sales) / Sum(TOTAL <$(=GetCurrentField(Dimension))> sales)
Would you be able to share a sample to look at what you had initially and what you have now?
issue is not coloring. Issue is that the RangeSum function returns wrong values. The graph is not cumulative.
Try this syntax if you have problem in Range sum function
RangeSum(first_expr[, Expression])
how to copy the App here?
I dont have the option to attach a file here. I have openned another discussion where I am able to attach the file.