[SOLVED] Please help! How to Count

July 11, 2011, 10:07 AM

 

			BODYTYPE				
			CONVERTIBLE	COUPE	HARDTOP	ROADSTER	SEDAN
COUNTRY	CAR	TOTAL 					
		COUNT					
ENGLAND	JAGUAR	2	1	0	0	0	1
ENGLAND	JENSEN	1	0	0	0	0	1
ENGLAND	TRIUMPH	1	0	0	1	0	0
FRANCE	PEUGEOT	1	0	0	0	0	1
ITALY	ALFA ROMEO	3	0	1	0	1	1
ITALY	MASERATI	1	0	1	0	0	0
JAPAN	DATSUN	1	0	0	0	0	1
JAPAN	TOYOTA	1	0	0	0	0	1
W GERMANY	AUDI	1	0	0	0	0	1
W GERMANY	BMW	6	0	0	0	0	6

I am working on generating a report looking exactly like the one above (using CAR example). The intention is to get total count of BODYTYPE and then get the component across count for each bodytype.

Please, can someone help me with a webfocus code to achieve this result. Thank you all.

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

July 11, 2011, 10:32 AM

Francis Mariani

TABLE FILE CAR
SUM
CNT.BODYTYPE AS ''
BY COUNTRY
BY CAR
SUM
CNT.BODYTYPE AS ''
BY COUNTRY
BY CAR
ACROSS BODYTYPE AS ''
HEADING
"BODYTYPE COUNT"
END

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 13, 2011, 09:36 AM

umun

Thank you Francis

July 13, 2011, 05:42 PM

Waz

This problem has beed answered several times before.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!