Order CROSSTAB

[tamise]

hello,

I need an help with another aspect of crosstab.
Indeed in this attachments you will see the crosstab that I created.

The thing is that i want to order the "... niveau 8"

Actually, report studio order by alphabeticaly but i dont want this.
For exemple, if "... niveau 8" output
A1
B1
A2
A3

I want to output
A2
B1
A2
A3

I use the property order but il is not working


thanks for you help

[BigChris]

I don't know if this will work in a crosstab, but you could calculate a field to sort on.

Case [Category]
  When 'Niveau 8' then
  Case [Field]
    When 'A2' then '1'
    When 'B1' then '2'
    When 'A2' then '3'
    When 'A3' then '4'
    Else [Field]
  END
  Else [Field]
END

Or something like that anyway...

C

[tamise]

Yess!!! Thanks it is working :)