Conference ilbbak::ibi_focus

48.0. "ACROSS MULTI RECORDS" by BAHAMA::KNIGHT () Fri Mar 18 1988 11:18

    How do you take multiple records and print a value across?
    
    I have a simple file of
    
    MONTH  AREA  SALES
      1    NE    1000
      2    NE    1010
      3    NE    1105
      1    WEST  2034
      2    WEST  2894
      3    WEST  3049
      1    MID    809
      2    MID    904
      3    MID   1405
    
    and want to create the report
    
             MONTH 
     AREA            1          2          3   
    -----------
     NE           1000       1010       1105
     WEST         2034       2894       3049
     MID           809        904       1405
    
    How do you do this?
    
    I've tried the following
    
TABLE FILE mysales
PRINT  sales 
ACROSS month 
BY area
ON TABLE SAVE AS SASUM FORMAT WP
END                                                                           

    and I get
    

             MONTH 
     AREA            1          2          3   
    -----------
     NE           1000          .          .
     NE              .       1010          .
     NE              .          .       1105
     WEST         2034          .          .
     WEST            .       2894          .
     WEST            .          .       3049
     MID           809          .          .
     MID             .        904          .
     MID             .          .       1405

    
    Ken :-(    
    
        

    
    
    	Replace the PRINT SALES with SUM SALES and it should
    	work fine.
    
    		Rich...