rangesum above in a straight table not working

[sarahshong]

I am trying to do a cumulative sum in a straight table with several dimensions using this formula

RangeSum(Above(Column(7), 0, RowNo()))

column 7 has the formula: 

Sum({$<[Bulk Rack]={'Rack'}>}[ASTM Quantity – BB6])+Sum({$<[Bulk Rack]={'Bulk'}>} [Volume (bbl)])

The output only gives out the result of that row and doesn't do a cumulative of the rows above. I have several dimensions and tried to add and aggr up to the month field but that gave me 0 and null values.

aggr(RangeSum(Above(Column(7), 0, RowNo())), Plant,Product, IDX_NM, EODMonth)

Any ideas on how I get a cumulative sum to work on my straight table for the month?

[sunny_talwar · Accepted solution]

@sarahshong  how about this

RangeSum(Above(TOTAL Column(7), 0, RowNo(TOTAL)))

[sarahshong]

Thank you Sunny! The TOTAL in front of the column is what I was missing in my attempts.