Crosstab Rows reordering

[raccess]

Hi,

Is it possible to reorder rows within crosstab as per requirement?

I'm using CR 10.0.

I have data format like,

Dept Dpt1 Dept2 Total
Account

Business Devp XXX XXX XXX
Comp & Benifit XXX XXX XXX
Global Support XXX XXX XXX
Revenue XXX XXX XXX

Total XXX XXX XXX

Here i want Revenue at top and then rest of accounts as per different grouping.

Is this possible in crosstab? OR how i can achive this?

Thanks,

R

 

[lbass]

While in the crosstab expert, highlight the row field->group options->specified order. Use the dropdown to select the row instances in the order in which you want them displayed.

-LB