Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Need help to populate running total in straight table with 2 dimensions. Attached sample qlikview application.
Dim1 | Dim2 | Sum | Running total |
A | a | 6863 | 6863 |
A | b | 21689 | 28552 |
B | c | 38056 | 66608 |
B | d | 49385 | 115993 |
C | e | 60542 | 176535 |
C | f | 69069 | 245604 |
Thank you !and looking forward to hearing from anyone
PFA Solution
Use this expression for Running Total
RangeSum(Above(TOTAL SUM(Expression1),0,RowNo(TOTAL)))
Please close the thread by marking answer correct if your query is resolved.