Hello

I am trying to do a COMPUTE for ACORSS but having issues. This is the final table structure after all the calculations and join.

TABLE FILE TAB1
SUM
	SALES
ACROSS SALE_DT AS ''
BY REGION AS ''
END

        2015-01  2014-12  2014-01 
West    27       29       26 
North   28       26       24 
South   32       31       25 

1st column (2015-01) will have the value as is but 2nd and 3rd columns should show a number after dividing 1st value and that column value.
for example -

for West  2015-01 will have 27
          2014-12 will have this value... (27/29)
          2014-01 will have this value... (27/26)
for North 2015-01 will have 28
          2014-12 will have this value... (28/26)
          2014-01 will have this value... (28/24)
for West  2015-01 will have 32
          2014-12 will have this value... (32/31)
          2014-01 will have this value... (32/25)

Desired Output:

        2015-01  2014-12  2014-01 
West    27       0.93     1.03 
North   28       1.07     1.16 
South   32       1.03     1.28 

Please suggest.

This message has been edited. Last edited by: Enigma006,

Try this:

  
TABLE FILE TAB1
PRINT
  SALES
AND COMPUTE
  FIRST/I1=(REGION NE LAST REGION);
  BASE/D12.2  = IF (FIRST) THEN SALES ELSE LAST BASE;
  SHOW/D12.2  = IF (FIRST) THEN BASE ELSE SALES/BASE;
BY REGION
BY HIGHEST SALE_DT
ON TABLE HOLD AS TAB2
END

TABLE FILE TAB2
WRITE
  SHOW AS ''
BY REGION
ACROSS HIGHEST SALE_DT
END

quote:

Originally posted by j.gross:
Try this:

  
TABLE FILE TAB1
PRINT
  SALES
AND COMPUTE
  FIRST/I1=(REGION NE LAST REGION);
  BASE/D12.2  = IF (FIRST) THEN SALES ELSE LAST BASE;
  SHOW/D12.2  = IF (FIRST) THEN BASE ELSE SALES/BASE;
BY REGION
BY HIGHEST SALE_DT
ON TABLE HOLD AS TAB2
END

TABLE FILE TAB2
WRITE
  SHOW AS ''
BY REGION
ACROSS HIGHEST SALE_DT
END

Thanks Jack. This worked. I had to make some conversions to alpha as I needed to add custom text etc to titles and data.