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?