Conference ilbbak::ibi_focus

579.0. "ACROSS, BY and Sub Totals" by MASALA::SACAMPBELL (Too Fast to Live, Too Young to Die !!) Thu Apr 07 1994 11:50

Hi,

I've a nice simple little FEX which produces a lovely matrix report which looks 
something like the following :


		SHIFT
		    1			    2
		OWNER
		PROCESS		PROD	PROCESS		PROD	TOTAL
 SECTION
-------------------------------------------------------------------------
DIFF				192	144		300	636
ETCH				 96	100			196
FILMS		  24		 24	 24		 24	 96

TOTAL		  24		312	268		324	928



The FEX to produce the report is as follows:

TABLE FILE HOLD
SUM NEW_QTY AS 'OUTS' ROW-TOTAL COLUMN-TOTAL
ACROSS SHIFT
BY OPR_GROUP_1 AS 'SECTION'
ACROSS OWNER
END



What I would like to do (and am having great trouble doing so) is have a sub
total after each shift.  I can't use sub-total or subtotal because these are
only allowes with BY phrases.

Eventuall the report should look like :


		SHIFT
		    1			    	    2
		OWNER		      SHIFT 1		      SHIFT 2	
		PROCESS		PROD   TOTAL	PROCESS	PROD   TOTAL 	TOTAL
 SECTION
-------------------------------------------------------------------------
DIFF				192	192	144	300	444 	636
ETCH		 		 96	 96	100   		100	196
FILMS		 24		 24	 48	 24	 24	 48	 96

TOTAL		 24		312	336 	268	324	592	928


Is this at all possible.

Thanx and Regards,


		Stuart.

    have you tried using   summarize   on the by statement??
    

I put the SUMMARIZE in the by phrase but got something that looked like this :

		    SHIFT
			1		2
		    OWNER
			A	B	A	B	TOTAL
SECTION
--------------------------------------------------------------------------
DIFF			72	25	24	60	229

*TOTAL DIFF
			72	25	24	60	229

ETCH			240		144		384

*TOTAL ETCH
			240	0	144	0	384

What I really need to do is SUMMARIZE/SUBTOTAL/SUB-TOTAL on the ACROSS phrase.


Thanx and Regards,

		Stuart.

    Sorry, I read your base note incorrectly.. Have you found the answer
    yet??
    
    bobh