Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-10-10 07:17 PM

Running sum based on outflow/inflow cash

My pivot table looks like this: http://i49.tinypic.com/ofsxs7.gif

It's sorted by date DESC (First dimension, "Effective Chec...").

I'm trying to get a running sum to get Amount of cash on hand in the "Amt" column.  You can see the Inflow and Outflow columns to its left...

I tried this, didn't work: =RangeSum(Above(TOTAL Sum(Amount),0,RowNo()))

312 Views
0 Likes
0 Replies