hi all i need i have to calculate the result value with my value which is from straight table
May be like this:
RangeSum(Above(TOTAL Value, 0, RowNo(TOTAL)))
If you are using a PIVOT TABLE
dimensions Date , Fund
Expression 1 :
Expression 2 : Will be useful for Fund wise Sub total
RangeSum(Above(SUM( Value), 0, RowNo()))
Expression 2 : Will be useful for Overall Total
RangeSum(Above(Total SUM( Value), 0, RowNo(Total)))
If it is Qlikview, We can get in 2 Ways
1. Expression tab you can see Full Accumulation Option, select that option and Expression as sum(Value)
2. Expression as Rangesum(above(sum(Value),0,count(Total Date)))
In Qliksense, We can Get only by using Expression.
Hope this helpful..
Retrieving data ...