Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurus,
As per the attached document i need to get Range sum, which is wokring fine in Table1 but when user moves the dimension to horizontal
"above" function does not work. do we have any other function to achive Range sum when dimension is horizontal, thanks in advance
Hi,
Try this expression
sum(Exp)
Before(sum(Exp))
RangeSum(Before(sum(Exp),0,ColumnNo()))
Regards,
Jagan.
Yes, the before() function should do the trick. And replace RowNo() with ColumnNo().
Hi Gysbert, thanks for quick reply but unfortunately Before does not work ...
Hi,
Try this expression
sum(Exp)
Before(sum(Exp))
RangeSum(Before(sum(Exp),0,ColumnNo()))
Regards,
Jagan.
That's very strange. It seems to work for me. See attached qvw.
Thansk a lot Jagan and Gysbert