Is there any way to sort a GROUP AGGREGATE?

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 :confused:

image

Looking forward to your responses.

Thanks in advance.

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

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?

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.

1 Like