Range sum is not working properly

[ajaymehtaece]

Hi All,

I am trying to calculate running sum in  pivot table using formula 
RangeSum (above(TOTAL Sum([Actual Qty]),0,RowNo()))/RangeSum (above(TOTAL Sum([Forecast Lag0]),0,RowNo()))

But this formula is not working when i am showing my table horizontally (first tabular chart).

However its working fine for vertical pivot table (second table).

kindly guide me why this is happening and what is the solution to bring running total in first chart.

[tresesco]

For horizontal calculation to work, replace all above() with before()

[tresesco · Accepted solution]

And yes, rowno() should be replaced with columnNo(). Therefore,

replace:

Above() with Before()

RowNo() with ColumnNo()

[ajaymehtaece]

Thanks Tresesco

Solution provided by is working fine for me.Thanks A Lot