Problem Rangesum when using dimension as column

[bert_geraerts]

Dear all,

I have a question regarding using rangesum in a pivot table, using columns.

I have an ordertable with for example 2 dimensions:

- ItemNr

- Date

- QTY

When I use a basic rangesum in a pivottable, I get the correct values:

rangesum(above(sum(QTY),0, rowno()))

However when I move the dimension "Date" from a row to a column, there is no more accumulation.

Is there any way of fixing this? 

Best Regards

[sunny_talwar · Accepted solution]

Try to change Above to Before and RowNo() to ColumnNo()

RangeSum(Before(Sum(QTY), 0, ColumnNo()))

[Sergey_Shuklin]

Hello!

Try to use ColumnNo() instead of RowNo().

[bert_geraerts]

So stupid of me, I didn't even realise the ColumnNo was a possibility.

I always thought the rowno stoot for row in the table and not in the object itselve.

Thanks a lot