I am new in using Focus/FML. I have the following data that I want to build an FML report.

Store Year Month Sales Cost Pin_Count,........

I want to make a new table look like the following.

Store

07 06 Variance
Sales
Cost
Pin_count


Anyone know how do I convert a column based table into a row based? Really appreciate your help.

Among

First we would like you to update your signature with the version you use and other functional information (platform etc)

I'm not sure if you need to do this with FML.

An other solution can be:

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

I'm sure there will be other solutions

Thank you Frank. It works fine. Another Question, Where do I put the header 2007 and 2006, VAR on the top and align them?