Skip to Content
0
Former Member
Jan 12, 2011 at 12:18 PM

Sorting in Bex Query

39 Views

Hi Experts,

I've got a report showing calyears side by side. When the user tries to sort by one key figure it does not sort the key figure in the year the user has selected but on the total of the key figure:


                  2009                    2010              Total
                  Quantity                Quantity          Quantity
Article 1         1                       1                 2
Article 2         3                       2                 5
Article 3         2                       5                 7

In the example above, the user want's to sort bei Quantity 2009 ascending. The result is sorted by Total.

Is there any way to allow sorting for by the values of an other column but the total?

Kindest,

Ralf