8 Replies Latest reply: Feb 19, 2017 7:01 AM by Mohammad Adnan Ansari RSS

    Line graph with Cumulative figures

    Mohammad Adnan Ansari

      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?

       

       

      SalesVSTarget.jpg