Running total in combo chart

[#1]

Hi All,

I'm trying to create a combo chart containing sales by month as a bar chart and a running total of sales as a line graph.

Does anyone know how to create the running total portion? I can only get the line chart to reflect the month by month sales (which is what the bar chart is already doing).

Thanks

[ali_hijazi]

rangesum(above(your_expression),0,rowNo(Total))

[sunny_talwar · Accepted solution]

Should be like this

RangeSum(Above(Sum(Sales), 0, RowNo()))

[#4]

You mean adding previous dimension expression value or anything else, can you explain in brief.

[#5]

RangeSum(Above(Sum(Sales), 0, RowNo())

The above calculation worked perfectly. Thank you for the quick response!