Skip to Content
0
Former Member
Jun 12, 2009 at 01:45 AM

Sorting by multiple fields

2046 Views

Hi gurus!

I'm facing a problem here.

I have a query with three key figures.

POINTS, VICTORY, BALANCE

In Bex Analyzer I can sort each key figure separately. (By Points or by Victory or By Balance).

But I have to sort by the three key figures on the following priority order: Points -> Victory -> Balance.

Example:

Points | Victory | Balance

A 1 1 2

B 1 1 1

C 1 0 4

D 0 22 1000000000000000

Anyone knows how to solve this problem?

Thanks,

Thiago