Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to change Above to Before and RowNo() to ColumnNo()
RangeSum(Before(Sum(QTY), 0, ColumnNo()))
Try to change Above to Before and RowNo() to ColumnNo()
RangeSum(Before(Sum(QTY), 0, ColumnNo()))
Hello!
Try to use ColumnNo() instead of RowNo().
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