Qlik Sense Table with RangeSum and Two Dimensions

[samyurchuk]

I have a table with the following columns:  NET_BILLING_AMT, Cumulative Sales and Material ID.  Using the formula rangesum(above(sum(NET_BILLING_AMT),0,rowno()))   for Cumulative Sales, everything works fine. 

I would like to add another Dimension  to the table called MATERIAL_NAME.  I've  tried aggr(rangesum(above(sum(NET_BILLING_AMT),0,rowno())), MATERIAL_ID, MATERIAL_NAME) for Cumulative Sales after adding the MATERIAL_NAME to the table but the column is not accumulating.

[marcus_sommer · Accepted solution]

Just try it without the aggr() but with TOTAL in rowno() and/or above() like:

rangesum(above(TOTAL sum(NET_BILLING_AMT),0,rowno(TOTAL)))

- Marcus

[samyurchuk]

Perfect!  That worked. Thanks for the help😊, Marcus.