Sorting second node in crosstab

[SynexusStuart]

Ok, this is a basic one but I've been having a brain fade...

I have data in a crosstab as follows:

          |   Region 1    |   Region 2     |
          | Pr(a) | Pr(b) | Pr(b) | Pr(a)  |
Row1 |   5     |    2    |   8     |   6     |
Row2 |   7     |    2    |   5     |   3     |
Total  |   7     |    2    |   5     |   3     |

Sorting the rows is fine. I have a sort on the Regions as well but when I try and sort on the Products (so that (a) appears before (b)) it won't work. - Basically (b) sometimes comes before (a).

I am sorting on that level (so i am not trying to sort both nodes from the Region level)

I have tried to add a sorting data item to the properties of the region level and use that but I get the same result. Can't work it out.

Anything obvious???

Thanks

[cognos810]

Hello SynexusStuart,
Not sure, if I got what you want to achieve, but have you added the sorting for the Product data item? Bascially, selecting the Node Member corresponding to Product, and then from the properties pane, add the sorting on Product.

-Cognos810

[SynexusStuart]

Hello SynexusStuart,
Not sure, if I got what you want to achieve, but have you added the sorting for the Product data item? Bascially, selecting the Node Member corresponding to Product, and then from the properties pane, add the sorting on Product.

Yes, that is set on the product data item. I can even see the ^ next to <#Product#> item.

[MFGF]

Yes, that is set on the product data item. I can even see the ^ next to <#Product#> item.

Hi Stuart,

How have you defined the sorting? Did you use the "Sort by label", "Sort in Layout", "Edit Set Sorting" or Edit Layout Sorting" option?

It is a dimensional or relational package?

Cheers!

MF.

[SynexusStuart]

Edit Layout Sorting.

Relational.

[MFGF]

Edit Layout Sorting.

Relational.

Hmmm. Ok. Not seeing anything obvious there. Do you have anything funky going on in your query? What happens if you build a new report with a simple crosstab from scratch and apply sorting on just Region then Product? Does that work? If not, can you replicate the problem using a sample package?

MF.