-SET &ECHO='ALL';
-DEFAULT &STATE_SEL='AL,AZ,CO,ID';
-TYPE &STATE_SEL

-* Convert ' OR ' to ', ' in the parameter list
-SET &STATE_SEL = STRREP (&STATE_SEL.LENGTH, &STATE_SEL, 4, ' OR ', 2, ', ', &STATE_SEL.LENGTH, 'A&STATE_SEL.LENGTH');
-TYPE &STATE_SEL

SQL SQLORA PREPARE REPORT FOR
SELECT * FROM SCHM1.TABLE1;
END

TABLE FILE BIWK_RPT_ACO
SUM
CNT_IF_3_65 AS '15-JUL-16'
CNT_IF_3_80 AS '29-JUL-16'
CNT_IF_3_90 AS '12-AUG-16'
CNT_IF_YTD_90 AS 'YTD_AVG'
BY DIVISION 
BY REGION 
BY STATE
BY DATA AS 'Data'
WHERE STATE IN (&STATE_SEL)
N DIVISION SUBTOTAL CNT_IF_3_65 CNT_IF_3_80 CNT_IF_3_90 CNT_IF_YTD_90 
ON TABLE PCHOLD FORMAT EXL07
END  

TABLE FILE CAR
SUM DEALER_COST
RETAIL_COST
COMPUTE RATE/D12.2%=DCOST/RCOST*100;
BY COUNTRY RECOMPUTE AS 'Subtotal:'
BY CAR
ON TABLE PCHOLD FORMAT HTML
ON TABLE RECOMPUTE 
END

 This is the o/p which I need to get(Expecting result):


Division 	Region 	State 	Data 			15-JUL-16 	29-JUL-16 	YTD AVG 2016
EAST 		E 	AL 	%Congest 		14.36% 		3.84% 		4.54%
				%Congest W/o AB 	4.69% 		0.37% 		0.59%
				Congest 		193 		52 		61
				Congest w/o AB 		63 		5 		8
				Polledunits 		1344 		1353 		1336

Total Division East 		%Congest Total 		14.36% 		3.84% 		4.54%
				%Congest 		4.69% 		0.37% 		0.59%
				Congest 		193 		52 		61
				Congest w/o AB 		63 		5 		8
				Polledunits 		1344 		1353 		1336

	
WEST 		MTW 	AZ 	%Congest 		2.45% 		0.91% 		0.99%
				%Congest w/o AB 	1.91% 		0.57% 		0.62%
				Congest 		227 		84 		91
				Congest w/0 AB 		177 		53 		57
				Polledunits 		9250 		9247 		9163


			CO 	%Congest 		3.23% 		1.32% 		1.45%
				%Congest w/o AB 	2.17% 		0.55% 		0.64%
				Congest 		394 		164 		161
				Congest w/0 AB 		264 		68 		71
				Polledunits 		12193 		12451 		11117

		w 	ID 	%Congest 		6.88% 		2.49% 		3.20%
				%Congest w/o AB 	4.45% 		0.82% 		1.24%
				Congest 		153 		55 		70
				Congest w/0 AB 		99 		18 		27
				Polledunits 		2223 		2207 		2178

Total Division West 		%Congest Total 		6.28% 		2.36% 		2.82%
				%Congest 		4.26% 		0.97% 		1.25%
				Congest 		774 		303 		322
				Congest w/o AB 		540 		139 		155
				Polledunits 		23666 		23905 		22458


Total for East &West		%Congest Total 		10.32% 		3.10% 		3.68%
				%Congest 		4.48% 		0.67% 		0.92%
				Congest 		967 		355 		383
				Congest w/o AB 		603 		144 		163
				Polledunits 		25010 		25258 		23794 


For the %'s( %Congest Total,%Congest )under the total ,the values should be the sum of the percentages divided by 2 and for the remaining ones(like
Congest,Congest w/o AB,Polledunits),it is the sum of the values.

Please let me know how to get this done.I tried subtotal,summarize and Iam not getting the above result which is expected.

But Babak's solution is not I need.This is the ouput which I need.

Could you or anyone please help me on this.

Thanks a lot in advance!

Regards,
IP