Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
And yes, rowno() should be replaced with columnNo(). Therefore,
replace:
Above() with Before()
RowNo() with ColumnNo()
For horizontal calculation to work, replace all above() with before()
And yes, rowno() should be replaced with columnNo(). Therefore,
replace:
Above() with Before()
RowNo() with ColumnNo()
Thanks Tresesco
Solution provided by is working fine for me.Thanks A Lot