DEFINE FILE SALES YEARS07=IF YEAR EQ 2007 THEN SALES ELSE 0; YEARS06=IF YEAR EQ 2006 THEN SALES ELSE 0; YEARC07=IF YEAR EQ 2007 THEN COST ELSE 0; YEARC06=IF YEAR EQ 2006 THEN COST ELSE 0; YEARP07=IF YEAR EQ 2007 THEN PCOUNT ELSE 0; YEARP06=IF YEAR EQ 2006 THEN PCOUNT ELSE 0; END TABLE FILE SALES SUM YEARS07 AS '' YEARS06 AS '' COMPUTE VARS=...(whatever your formula will be) AS '' OVER YEARC07 AS '' YEARC06 AS '' COMPUTE VARC=...(whatever your formula will be) AS '' OVER YEARP07 AS '' YEARP06 AS '' COMPUTE VARP=...(whatever your formula will be) AS '' BY STORE NOPRINT ON STORE SUBHEAD "<STORE" WHERE YEAR EQ 2007 OR 2006; END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |