Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a question in regards to totals accumulations in a pivot table. This may be very simple.
The pivot table I have is for stock transactions and shows the months across the top as columns and for each month it has the Purchases, Sales etc. as row expressions.
The first column (month = 0) has the opening stock balance.
At the bottom I have the Totals expression for each month (ie. Purchases - Sales - Back orders) which is bascially supposed to be the projected stock on hand and include the net of the current month and all Totals before it
I can accumlate the previous record, by using the before() function and I can also get the initial stock with the first() function, but I need to look at all months before, not just the previous.
I tried rangesum and aggr functions, but have not been able to work out how to do it.
###### Update: Found my answer in this post: http://community.qlik.com/forums/p/26097/100033.aspx
Maybe someone could point me in the right direction here?
What was the solution? I am having the same issue and the link does not work.
Simple !
RangeSum(Before(Sum(FIELD), 0, ColumnNo()))
JP