[SOLVED] Display subtotal in BY field

April 03, 2014, 02:13 PM

This is my example using BY for Name and ValueTable1:

 
Name   ValueTable1     ValueTable2
AAA             11             11
                               22
BBB             22             11
                               22

When I add Subtotal, the result will be:
Name   ValueTable1     ValueTable2
AAA             11             11
                               22
Total                          33   
BBB             22             11
                               22
Total                          33

How can I display subtotal for ValueTable1 like below:
Name   ValueTable1     ValueTable2
AAA             11             11
                               22
Total           11             33   
BBB             22             11
                               22
Total           22             33

Thanks in advance.

This message has been edited. Last edited by: <Kathryn Henning>,

April 04, 2014, 02:47 AM

Danny-SRL

Hi Hainguyen,

See an example using the CAR file:

  
-* File HAINGUYEN01.fex
DEFINE FILE CAR
SEAT_TYPE/A12=DECODE SEATS(2 SPORT 4 FAMILY 5 WAGON ELSE CAR);
END
TABLE FILE CAR
PRINT 
COMPUTE TSEATS/I3S=IF SEATS NE LAST SEATS THEN SEATS ELSE 0; AS SEATS
SALES
BY SEAT_TYPE SUBTOTAL
BY SEATS NOPRINT
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT, $
ENDSTYLE
END