how to eliminate duplicate headings?

[Mapril]

Hi experts,

I grouped a range of sales numbers by using specific order. For example, sales numbers such as $1,000, $4,000, $7,000 etc, I put them into a heading "$1,000 - $9,999" and sales figures such as $10,000, $50,000, $90,000", I put them into a heading called "$10,000 - $99,999".

My problem is: the heading repeats for each group of sales numbers. For example, $1,000 - $9,999" heading appears on $1,000, $4,000 and $7,000 records. For example:

$1,000 - $9,999
Record 1 $1,000

$1,000 - $9,999
Record 2 $3,000

$1,000 - $9,999
Record 3 $3,000

$1,000 - $9,999
Record 4 $9,000
.
.
.

$10,000 - $99,999
Record 20 $20,000

$10,000 - $99,999
Record 21 $20,000

$10,000 - $99,999
Record 22 $50,000

My question is: how to keep one heading for all the numbers that fall into the same range? I want the table looks like:

$1,000 - $9,999
Record 1 $1,000
Record 2 $3,000
Record 3 $3,000
Record 4 $9,000

$10,000 - $99,999
Record 20 $20,000
Record 21 $20,000
Record 22 $50,000
.
.
.

Many thanks in advanced.

 

[lbass]

You should be using one formula like this:

if {table.amt} >= 1000 and
{table.amt} < 10000 then "$1,000 - $9,999" else
if {table.amt} < 100000 then
"$10,000 to $99,999" else
if {table.amt} < 200000 then
"$100,000 - $199,999" else//etc.

Insert a group on this or use as a row in a crosstab.

-LB

 

[Mapril]

Thanks a lot of your help, LB.