Records Counts in Tiers

[insipid1991]

I need a report to show me the following output for client employee count:

Employees # Clients % of Total
1-2 15 14.5%
3-5 24 23.3%
6-10 21 20.4%
11-20 28 27.2%
21-25 4 3.9%
26-50 7 6.8%
51+ 4 3.9%
Total 103

Average Employee Count 12


I have tried using multiple define statements, but to no avail.

Any coding ideas?

Table Name Example = CLIENT_MASTER

Field Names Example:
CLIENT_NAME
CLIENT_NUMBER
EMPLOYEE_COUNT


Thanks so much!


Doug

 

[craigiep]

Doug,

TABLE FILE CLIENT_MASTER
SUM CNT.CLIENT_NAME AS '# Clients'
PCT.CNT.CLIENT_NAME AS '% of Total'
BY EMPLOYEE_COUNT AS 'Employees'
END

will hopefully give you what you need.

 

[insipid1991]

That's it! I incorporate your info with some research I did to come up with it.

Thanks!

 

[insipid1991]

That's it! I incorporated your info with some research I did to come up with it.

Thanks!