I am trying to get record count using a subfoot. if you look at the sample output below you'll notice that the third retailer print hte door count following the the third sort break, not the second. How can I get it to print before the third sort total line?

quote:

**TOTAL CLASS: **UNKNOWN**
***TOTAL ACCOUNT: PARISIAN
DOORS:1


**TOTAL CLASS: SUBURBAN
***TOTAL ACCOUNT: RLGM
DOORS:1

**TOTAL CLASS: **UNKNOWN**
***TOTAL ACCOUNT: ROBINSONS/MAY
****TOTAL : WOMENS HOSIERY
DOORS:1

The code I used to get this is:

.
.
DOORS/I5 = 1;
.
.
ON BY_CLASS RECOMPUTE AS '**TOTAL CLASS:'
ON NAM201 RECOMPUTE AS '***TOTAL ACCOUNT:'
ON NAM201 SUBFOOT
"DOORS:ON CMP_NAM RECOMPUTE AS '****TOTAL :'
Thanks in advance.

This message has been edited. Last edited by: <Mabel>,

what is the order of your BY fields? i.e. what does your internal matrix look like?

Here are my by fields as well as breaks....

quote:

BY CMP_NAM AS '' NOPRINT
BY NAM201 AS 'ACCOUNT'
BY BY_CLASS NOPRINT
BY STR_ID AS 'STORE'
BY SNM003 AS 'STORE NAME'
BY MALL_NM AS 'MALL '
BY CLASS_NM AS 'CLASS'
ACROSS DIV_ID NOPRINT AS ''
ACROSS NAM500 AS ''
-*
ON BY_CLASS RECOMPUTE AS '**TOTAL CLASS:'
ON NAM201 RECOMPUTE AS '***TOTAL ACCOUNT:'
ON NAM201 SUBFOOT
"***DOORS: <ST.DOORS"
ON CMP_NAM RECOMPUTE AS '****TOTAL :'
ON NAM201 PAGE-BREAK
ON CMP_NAM PAGE-BREAK