how to display the values of calculated member of a crosstab in serial order???

[everlearner]

Hi gurus,

In cross tab i defined query calculation called "status", and it has 3 values s1,s2,s3.
where am displaying how many requests placed in a particular status..
when i run the report in the output it is displaying the status not in serial order.it is displaying like s2,s1,s3
how would i display them in serial s1 s2 s3.

thanks in adv

[wyconian]

Can you just sort the column?

[everlearner]

hi wyconian, if i sort the column the values in the column will be display in order.

here the below am giving an example

my output coming like this

S2   S1   S3
12   23   45

but it has to come like
S1   S2   S3
12   23   10

so here i want to display the S1 S2 S3 in a order...

[HalfBloodPrince]

Try this out
create a sort key Column If(dataitem='s1' )  then (1) else If(dataitem='s2' )  then (2) etc .
then go to edit layout sorting . in that under Detail sort list , first add sort key , then add dataitem.

[everlearner]

Hi Prince,

Thanx for ur reply. i have created a column and defined as u told. then done the sorting. after that also i didt get it.
could please explain me steps in detail. i will try again..

Thanx in adv

[everlearner]

Hi Prince,

I got it, i did a mistake. that i fixed. now i got the required output. once again thanks prince.

[Shivanand]

hi
it has nothing to do with the sort, you just have to place the data items in that order
S1  S2  S3 in the report page, I mean you just have to reorder them the way you want in the report page, and it should solve the problem.