I'm trying to do a report as below.
Region CNT1 CNT2
A 15 10
25 50
--------------------------
Count 2 Avg 20 30
--------------------------
B 15 20
25 50
35 50
--------------------------
Count 3 Avg 25 40
--------------------------
I looked into RECAP and SUBTOTALS,but I am not the desired results. Any ideas ?

Thanks !

Here is one way.

TABLE FILE X
SUM
AVE.CNT1 NOPRINT
AVE.CNT2 NOPRINT
BY REGION
PRINT
CNT1
CNT2
BY REGION
ON REGION SUBFOOT
"--------------------------------------------"
"Count <ST.CNT.CNT1 Avg <AVE.CNT1 <AVE.CNT2"
"--------------------------------------------"
END

Another cool new feature (FOCUS release 7.3 and WF release 5.2.x) is to use prefixes in your subtotal. It will average what was summed. So,

Sorry, I pressed ENTER too soon:TABLE FILE fn
PRINT CNT1 CNT2
BY REGION
ON REGION SUBTOTAL AVE. CNT1 AVE. CNT2
END Note the space after the AVE.