Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See the example attach
Hi,
You have a couple of things wrong with your expression:
RangeSum(Above(total Sum(Value),0,RowNo(TOTAL)))
Now, the only problem is that it will not aggregate if the dimension is collapsed. This is because if it is collapsed, the Above(Total Sum(Value)) doesn't make any sense - there is no row above.
Regards,
Stephen