Accumulating line by line

[#1]

Hello people,

I'm adding this worksheet to better explain my problem.

in column H i have a cumulative value. which is actually the value of the cell above it but the same result.

Tried the RANGESUM.

[#2]

hi,

get accumulated with this expression.

RangeSum (Above (Total Sum (QTD_EMBALAGEM), 0, Rowno (Total)))

only after I put this espresão can not sort by the expression to be in column 1.

[#3]

hi

try this

expression1--- QTD_EMBALAGEM

Expression2----RangeSum(Above(sum(QTD_EMBALAGEM),0, rowno()))

[angelaecheverri]

sum(Total qtd) = sums all the records for qtd taking care of your selections

sum(all qtd) = sums all the records of your data... its doensnt take care of your selections...

[#5]

Hi Angela,

then how is my these two expressions: Sum (QTD_EMBALAGEM) and RangeSum (Above (sum (QTD_EMBALAGEM), 0, Rowno (TOTAL)))?

I have to sort from highest to lowest the Sum (QTD_EMBALAGEM) expression.

and I can only sort by dimenssões.

[#6]

Hello people,

to make it easier I made this example.

[angelaecheverri · Accepted solution]

I dont get what are you saying...

you can sort by dimension and by expresions....

if you want to sort by an exprssion...

just go to sort and do it by exprresion...

[#8]

do not know how I did not think of that before.

Thank you Angela

[angelaecheverri]

Your welcome