Pivot table Above or Range sum issue

[#1]

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

[Gysbert_Wassenaar]

Yes, the before() function should do the trick. And replace RowNo() with ColumnNo().

[#3]

Hi Gysbert, thanks for quick reply but unfortunately Before does not work ...

[jagan · Accepted solution]

Hi,

Try this expression

sum(Exp)

Before(sum(Exp))

RangeSum(Before(sum(Exp),0,ColumnNo()))

Regards,

Jagan.

[Gysbert_Wassenaar]

That's very strange. It seems to work for me. See attached qvw.

[#6]

Thansk a lot Jagan and Gysbert