Hard nested rows sorting in a crosstab with multiple measures

[Rosanero4Ever]

Hi all,

I have a crosstab as displayed in the attached picture.

The objective of this crosstab is to display revenue, costs, orders and margin for each customer and centers of cost.
So, I would like sort (descending) customers using the margin measure
In this way, I selected customer rows and I used the layout sort funcionality and the margin measure in the sort list.
But, as you can see, I cannot sort rows in a descending way using the margin (67.268,63 must be displayed after 75.151,40)
Where do I fail? How can I obtain the described  sorting?

[MFGF]

Hi all,

I have a crosstab as displayed in the attached picture.

The objective of this crosstab is to display revenue, costs, orders and margin for each customer and centers of cost.
So, I would like sort (descending) customers using the margin measure
In this way, I selected customer rows and I used the layout sort funcionality and the margin measure in the sort list.
But, as you can see, I cannot sort rows in a descending way using the margin (67.268,63 must be displayed after 75.151,40)
Where do I fail? How can I obtain the described  sorting?

Hi,

This is exactly the process I would use. I just tried an example using the sample GO Sales (query) package and it works fine for me.

I have attached my report spec below.

Cheers!

MF.