Problem with grouping/sorting in crosstab

[CognosMarson]

Hi,

I have a problem with grouping/sorting (for lack of a better word) in crosstab.

I want the result with the green header, but I get the result with the red header, please see attached picture.

I know I can get this result by creating a hierarchy and filter it on another key in the fact table, but if the hierarchy is missing and for some reason I'm not having access the the cube, is there a way to get around this in the reporting section and creating the desired crosstab?

Cheers CM