why after add accumulated col my sales column unable to sort from hi to lo ?

[#1]

Hi All

I notice some thing very funny. hope some one can share with me why this happen ?

Before add Accumulated sales , sales Column is sort from high to low , ( see table 1 ) . Why after add the Accumulated sales , Sales column is not sort from high to low ? ( See Table 2)

See the enclosed QV doc.

[Clever_Anjos · Accepted solution]

Everytime you use Rowno() or Rank() into a expression this 'bugs' sorting.

Use the feature of "Full Acumulation" instead

[#3]

you are so clever .