Cumulative line graph

[Anonymous]

Hi,

I want to create cumulative line graph

The data is like

Date       Profit    Capital    

1/1/17      10          100

2/1/17      30           200

3/1/17      40          300

4/1/17      50           400

I want to divide Profit/Capital and want to take cumulative of that as an expression to chart.

Any suggestions?

[Anonymous]

Hi Sunny,

I want to calculate Column F in the attached sample. Any help?

Thanks

[sunny_talwar · Accepted solution]

Try this

RangeSum(Above(If(RowNo() = 1, 1, Sum(PL)/Sum(Capital)), 0, RowNo()))