Hi guys,
I have been searching on some forums for this sorting issue but so far have not found a solution for the below described problem yet.
A crosstab report, created on a dimensional data source, having 3 columns: Account Number(1), Account Name (2) and Revenue (3)
The sorting is required on the second column (Account Name)
Acct No Account Name Revenue
N1 A1 100
B1 1200
N2 A2 500
B2 700
The report is expected to be displayed as below:
Acct No Account Name Revenue
N1 A1 100
N2 A2 500
N1 B1 1200
N2 B2 700
I have tried to put a Sort on Account Name and set Source Type = Data Item Value. But it did not work! The sorting only works when the order of the first 2 columns are switched (Account Name to be the first column!) But then the measure value (Revenue) is not correct.. I doubt that there is a grouping automatically set on different columns in each case!
Any suggestions for a solution or reference to some previous discussions about this would be very much appreciated!!!
Rgrds,
SB