Running Balance Line Chart

[BouwerVa]

Hi 

I made the following line chart showing our daily LG. But I would like the line to increase with each days LG.

I add a Screenshot with the Line Chart and Dimension. The Chart is filtered for a Specific Month.

[kaushiknsolanki]

Hi,

I guess what you are looking for is a cumulative chart.

Here is the link to know how to do it.

https://www.youtube.com/watch?time_continue=3&v=AlT_jAMsiGU

Regards,

Kaushik Solanki

[BouwerVa]

It is working in Table but not in Line Chart

 

[kaushiknsolanki]

Hi, Did you check the video?

Regards,

Kaushik Solanki

[BouwerVa]

Yes

Here is my Formula:

RangeSum( Above( Sum(if(TTYPE = 'Lo' and TGROUPTYPE = 'Lo', CAPITAL)),0,RowNo() ) )

[kaushiknsolanki]

Hi,

Can you share the sample qvf file.

Regards,

Kaushik Solanki

[BouwerVa]

It is working in the table in the Screenshot above.

But when I convert the table to line graph is doesn't work

[kaushiknsolanki]

Hi,

I need to understand whats going wrong and thus i need the sample qvf.

Regards,

Kaushik Solanki

[BouwerVa]

See Attached qvf

It is under the Daily LG Sheet

[BouwerVa]

Hi

Any luck on solving the problem?

Did you have time to have a look at the qvf?