how to sort specified headings?

[Mapril]

Hi all,

I grouped my records by using sales revenues (e.g. $1,000, $5,000, $7,500....etc). For those records don't have sales, I was able to put "no sales" by using specified order.

However, now I can't sort those headings in descending order - from max. sales to "no sales". (right now my headings are sorted from min. sales to max. sales and "no sales" is at the very end.

Can anyone please give me some ideas? Do I need to use a formular?

All advice is appreciated. Thanks.

MA

 

[lbass]

Don't use specified order, use descending order. In the group expert, select the group->options->customize name->x+2 and use a formula like this:

if {table.sales} = 0 then
"No Sales" else
{table.sales}

-LB

 

[lbass]

Sorry, that should have been:

if {table.sales} = 0 then
"No Sales" else
totext({table.sales},0)

-LB

 

[Mapril]

Thanks LB, it works.