May 01, 2006, 01:22 PM
Spencesee if this code helps.
TABLE FILE CAR
SUM SALES
ACROSS COUNTRY AS ''
COLUMNS JAPAN AND ENGLAND AND 'W GERMANY' AND FRANCE AND ITALY
-*ACROSS COUNTRY
-*ACROSS FISCAL_MONTH AS ''
-*COLUMNS Jan AND Feb AND Mar AND Apr AND May
-*AND Jun AND Jul AND Aug AND Sep AND Oct AND
-*Nov AND Dec
END
May 02, 2006, 04:31 AM
<Special-K>Sort on a month number first,e.g.
DEFINE FILE MONTHS
MTHNUM/I2= IF MTH EQ 'JAN' THEN 01 ELSE
IF MTH EQ 'FEB' THEN 02 ELSE
IF MTH EQ 'MAR' THEN 03 ELSE
...
...
...
END
TABLE FILE MONTHS
SUM CARS
BY MTHNUM NOPRINT
BY MTH
END