Skip to Content
0
Former Member
Jul 17, 2008 at 01:24 PM

Group by operator mismatching order of records

18 Views

Hi you all,

I've noticed that using the Group by" block will change the order of records in the table. For example if I have, before the "Group by" block, a situation like the following:

Country                           Sales
OVERALL RESULT                     2500
UK                                 2000
IRELAND                             500

after grouping by characteristic "Country" and summing key-figure "Sales", the result changes as follows:

Country                           Sales
IRELAND                             500
OVERALL RESULT                     2500
UK                                 2000

In other words, the "Group by" operator automatically sorts by the name of the characteristic grouped.

Does anybody know if there is a method or a workaround that could avoid this behavior?

Thank you,

Andrea

Edited by: Andrea Marchini on Jul 17, 2008 3:25 PM