Sorting problem with last and before

[#1]

Hi all,

I am calculating the $ Change column with this expression

=(before( sum(Balance), 1 ) - sum(Balance))

Now the problem is, I want to sort this in ascending order, basically find out which account has the most declined balance.

I tried the following expressions for sorting but both do not seem to be working.

=(before( sum(Balance), 1 ) - sum(Balance))

or

=last( (before( sum(Balance), 1 ) - sum(Balance)))

Has anyone had any luck getting this working before?