Running total in a pivot table

Tue, 31 Jan 2017 11:29:18 GMT

Hi,

In the table above I have used the expression

$(vBalance)+RangeSum(Above(TOTAL Column(1) - Column(2), 0, NoOfRows(TOTAL)))

to get the Balance column. Now I need to represent the same data in a pivot table as follows

I've used ($(vBalance)+RangeSum(before(TOTAL sum(Arrival) - sum(Dispatches), 0, ColumnNo(TOTAL))))

which gives the 1st row(for Jan) of the pivot table right.But gives incorrect results for the other rows.

I have attached the application I've been working.

Can anyone help me with creating the table I wish for?

topic Running total in a pivot table in QlikView