Crosstab - Sort

[peewan]

I'm using crosstab, and would like to sort my report.

Current:

          Male D   Female D   Female Sp      Female EE   Male EE   Male Sp   
0 to 18       7            5            0                1                      0                0            
19 to 26      1            1            1                1                      2                0            
27 to 29      1            1            1                1                      1                6

If I sort 'Gender' by A-Z; will be: Female EE\Female D\Female Sp\Male EE\Male D\Male Sp

I would like it: Male EE\Female EE\Male Sp\Female Sp\Male D\Female D

or at lease Male and female the same department go together.
Thank you

[MFGF]

I'm using crosstab, and would like to sort my report.

Current:

          Male D   Female D   Female Sp      Female EE   Male EE   Male Sp   
0 to 18       7            5            0                1                      0                0            
19 to 26      1            1            1                1                      2                0            
27 to 29      1            1            1                1                      1                6

If I sort 'Gender' by A-Z; will be: Female EE\Female D\Female Sp\Male EE\Male D\Male Sp

I would like it: Male EE\Female EE\Male Sp\Female Sp\Male D\Female D

or at lease Male and female the same department go together.
Thank you

Hi,

Try adding a query calculation to your query:

CASE [Gender] 
WHEN 'Male EE' THEN 1
WHEN 'Female EE' THEN 2
WHEN 'Male SP' THEN 3
WHEN 'Female SP' THEN 4
WHEN 'Male D' THEN 5
WHEN 'Female D' THEN 6
ELSE 0 
END

You can then sort your column edge based on this. You may need to add it to the Properties property of the column edge.

Cheers!

MF.

[peewan]

THANK YOU! THAT WORK GREAT!