Country Car Cost
A1      B1    10
A1      B2     2
Subtotal A1   12
B1      C1     8
B1      C2    12
Subtotal B1   20

Subtotal A1   12
Subtotal B1   20

  
-* File Fernando1.fex
SET NODATA = ' '
JOIN BLANK WITH SALES IN CAR TO BLANK IN FSEQ AS B_
-*
DEFINE FILE CAR
BLANK/A1 WITH SALES=' ';
XCOUNTRY/A16=IF COUNTER EQ 2 THEN 'Total ' | COUNTRY ELSE COUNTRY;
XCAR/A16=IF COUNTER EQ 2 THEN ' ' ELSE CAR;
END
-*
TABLE FILE CAR
SUM SALES
BY COUNTER NOPRINT SUBFOOT
" "
BY XCOUNTRY AS COUNTRY 
ON XCOUNTRY SUBTOTAL AS 'Total' WHEN COUNTER EQ 1
BY XCAR AS CAR
WHERE COUNTER LE 2
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ONLINE-FMT STANDARD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF, $
ENDSTYLE
END

  
  COUNTRY           CAR                SALES                                    
  -------           ---                -----                                    
  ENGLAND           JAGUAR             12000
                    JENSEN                 0
                    TRIUMPH                0
  
  Total ENGLAND                        12000
  
  FRANCE            PEUGEOT                0
  
  Total FRANCE                             0
  
  ITALY             ALFA ROMEO         30200
                    MASERATI               0
  
  Total ITALY                          30200
  
  JAPAN             DATSUN             43000
                    TOYOTA             35030
  
  Total JAPAN                          78030
  
  W GERMANY         AUDI                7800
                    BMW                80390
  
  Total W GERMANY                      88190
  
   
  Total ENGLAND                        12000
  
  Total FRANCE                             0
  
  Total ITALY                          30200
  
  Total JAPAN                          78030
  
  Total W GERMANY                      88190