I would like to have the report subtotal only if the CAR.BODY.SEATS = 2. Can this be done?
TABLE FILE CAR
SUM
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
BY LOWEST CAR.BODY.SEATS
BY LOWEST CAR.SPECS.MPG
ON CAR.BODY.SEATS SUBTOTAL AS 'Subtotal'
END
This message has been edited. Last edited by: Trudy,
WF8 Windows
August 25, 2017, 12:01 PM
MartinY
TABLE FILE CAR
SUM CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
BY LOWEST CAR.BODY.SEATS
BY LOWEST CAR.SPECS.MPG
ON CAR.BODY.SEATS SUBTOTAL AS 'Subtotal'
WHEN SEATS EQ 2;
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007