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?
Quote from: Rosanero4Ever on 02 Nov 2016 03:08:48 AM
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.