Cumulative cost in multiple axis line char

[minuz1991]

Hello,

I'm trying to calculate cumulative cost in my depth vs days and cost diagram. For example the cost should look something like that :

Day_Cost         Cumulative_Cost

150$                 150$

150$                 300$

200$                 500$

 

I'm trying to achieve this by using CHART PROPERTIES ->CHART DATA->CONFIGURATION AND MODIFY MY COST MEASURE.

In the Cost measure I select calculation as a SUM and value expression as my day_cost, however, I'm not seeing any cumulative values. Is it possible to calculate cumulative value using my method or is it need to be calculated in MySQL query and if so, how would I do it without setting variables to store cumulative value. 

Here is a screenshot of my results, the red line shows linear progression that I want to achieve using cumulative costs. 

Any suggestions?

[lucianc]

Directly computing running/cumulative totals via measures is not possible.

The only option is to compute the total with report variables, and then pass the computed values to the chart.  See an example in the attached report (run with the Sample DB).

Regards,

Lucian