i want to get output like this....

Product Count
ProdA 1
ProdA 2
ProdA 3
ProdA 4
ProdB 1
ProdB 2
ProdB 3
ProdC 1
ProdC 2
ProdC 3
ProdC 4
ProdC 5

I'd appreciate any help...thanks!

This message has been edited. Last edited by: Kerry,

How is your data stored ? May be you need to provide more details? Is product the detail level of information.

Assuming you first sort the data BY PRODUCT, and hold it AS YOURFILE then the following will number them as you wish:

DEFINE FILE YOURFILE
PRODCOUNT/I4=IF PRODUCT EQ LAST PRODUCT THEN PRODCOUNT + 1 ELSE 1;
END

TABLE FILE YOURFILE
PRINT PRODCOUNT 
BY PRODUCT
END

Worked perfectly!

I was hoping it was easy and it was!

Thanks for your help!

You could also use LIST, but this depends on the data

TABLE FILE {table}
LIST {field}
BY PRODUCT
END

When asking for help like this, more infor helps us.

you are correct...i should have provided more information on this....I appreciate everyone's willingness to help

thanks again

I also thought about LIST and also RANKED, but both of those would put the numbers to the left of the product, not to the right, which was the original request.

i'll keep those in mind...it didn't matter which side the numbers appeared..i had on the right as an example.

thanks again.

RANK BY Filed?