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.