In my report I need to create line that is difference between Company total and few subtotals for customers.

Result must be as follow:

customer1 ..........( data from file)
customer2 ..........( data from file)
subtotal for both customers
customer3 ..........( data from file)
customer4 ..........( data from file)

Independent customer line = subtract subtotal for both customers and customer4 from Company totals

Company totals ..........( data from file)

Please, give me a hint!

If you know the identity of all of the customers
who will be in the report you can specify each of
them in a ROW controlled report using the FOR
option. eg..

SUM VALUE FOR CUSTOMER
NAME1 OVER
NAME2 OVER
RECAP TOTAL= R1+R2 ; OVER
NAME3 OVER ...

This is the FML option, but can be used with any data. In Dev Studio after picking the FOR field
click the 'Matrix' button. Or read the documentation for the FML .

This also might work. Bucket the values in a DEFINEd field and then sort by that with a NOPRINT and SUBTOTAL. Example.

DEFINE FILE CAR
FLAG/IA10 = IF COUNTRY EQ 'ENGLAND' OR 'ITALY' THEN 'Group 1' ELSE 'Group 2';
END
TABLE FILE CAR
SUM RCOST DCOST
BY FLAG NOPRINT SUBTOTAL
BY COUNTRY
END