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