SUBFOOT with ACROSS

[kiddpete]

I am trying to write a report like this:

TABLE FILE XYZ
SUM ALPHA
BY SEQ NOPRINT
BY ALPHA NOPRINT
SUM DOLLAR
ACROSS PERIOD AS '' ROW-TOTAL COLUMNS Q1 AND Q2 AND Q3
BY SEQ NOPRINT
ON SEQ SUBFOOT
" "
&quot;INT PLAN <SEQ><19><ST.C2><30><ST.C3>&quot;
&quot; &quot;
BY ALPHA NOPRINT
END

Where C2 is the value of DOLLAR for column Q1.

When I run this, Focus says it doesn't know what C2 and C3 are. When I remove the 'ST.', the report works for C2, but C3 is random characters.

How do I get the subtotal? How do I get DOLLARs for Q2 and Q3?

 

[focwizard]

The problem is, you can't use a ST. prefix on a 'column notation'. What you can do is use RECAP (which will use subtotal values) to 'name' the 'C' values, then reference the RECAP in the SUBFOOT. Here's an example from the CAR file:

TABLE FILE CAR 
SUM CAR            
BY COUNTRY NOPRINT  
BY CAR NOPRINT     
SUM SEATS       
ACROSS BODY AS '' ROW-TOTAL COLUMNS SEDAN AND COUPE AND HARDTOP  
BY COUNTRY NOPRINT        
ON COUNTRY RECAP       
STC2/I3=C2;        
STC3/I3=C3;                          
ON COUNTRY SUBFOOT                 
" "   
&quot;INT PLAN <CAR><19><STC2><30><STC3>&quot;  
&quot; &quot;                                
BY CAR NOPRINT                       
END

My reference to C2 and C3 in the RECAP is the subtotal of those columns at the COUNTRY level.

 

[kiddpete]

Thanks focwizard.