Issue with sorting in crosstab

[vraju.springs@gmail.com]

Hi all I have a requirement . I have to sort product lines in custom order that is user required order it neithe assending nor descending in row of cross tab  and the type of data is dimensional data.
Eg: CGMOP should be displayed as MCPOG
I have tried my best but unable to accomplish.Please help me

[MFGF]

Hi,

Is your user building the crosstab, or just running a report authored by someone else?  If they are building it, they can simply drag in the relevant product line members in the desired order. Other than this, there is no easy way - the only sorting options are ascending and descending. You would need to pre-define a calculation that assigns a value to each member that could be sorted to give the correct result, but I imagine there are a lot of different permutations?

MF.