Is there any way to sort a GROUP AGGREGATE?

[Jasper_Daanoy]

Hi everyone,

Is there any way to sort a group aggregate value or a virtual column? Tried using the sort option on view options but did not work

Looking forward to your responses.

Thanks in advance.

[Aleksi]

I’m afraid you can only sort with the group value itself.

[Jasper_Daanoy]

Yeah, tried sorting it using the group value. But didn’t worked as well. Does being a calculated virtual column makes it impossible to sort?

[Aleksi]

Yes it would work but you need to add that value to the beginning like $1000 Bayugan Sales Center. Not very elegant solution but doable. If you have lot of rows to calculate, it can also be time consuming solution.