I am in the process of writing a report. I want to show two columns sort data as one colum and indent top sort to 2nd sort.
In first sort for example:

  
DESCRIPTION
ENDLAND
   CARNAME1
   CARNAME2

JAPAN
   CARNAME1
   CARNAME2

Now after I have this indenting done I would like to add a user defined compute for in the middle of column value:
ENGLAND
   Jaguar      8000
   JENSEN      1000

JAPAN
   TRIUMPH     9000
TRIUMPH-JAG    1000
   DATSUN      11000
England-Japan  (11000)

ITALY
   ALFA        20000
   ROMEO       29000
ENGLAND-Itly   (40000)

Is it possible?

The first part is easy. Just put the Country in a subhead:

ON COUNTRY SUBHEAD
"<COUNTRY"

and use the IN marker on the indented field:

CAR IN 5

or 

CAR IN +5

As for the rest of the question, you can put a SUBFOOT or RECOMPUTE at the bottom of every COUNTRY section, but you will have to probably use a double verb to compute the ENGLAND total for the entire report so it can be used at various places in the report.

Darin,
Thank you so much for great suggestions. I think my report is little more complicate than I explained(My fault).

Here is the code for my report:

PRINT 
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CCW/I11CB' AS 'Current ,Week'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PriorYearChange/I7CB'
 AS 'CW vs PY,Change'
     'J1.DWMETRICSDESCRIPTION.PYCPct' AS 'CW vs PY,Change%'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPW/I11CB' AS 'Prior ,Week'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PWPYChange/I7CB' AS 'PW vs PY,Change'
     'J1.DWMETRICSDESCRIPTION.PWPYPct' AS 'PW vs PY,Change%'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPT/I11CB'
 AS 'Current Period,To Date'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PTDChange/I7CB' AS 'PTD vs PY,Change'
     'J1.DWMETRICSDESCRIPTION.PTDPct' AS 'PTD vs PY,Change%'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPP/I11CB' AS 'Prior ,Period'
     'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PPTDChange/I7CB' AS 'PP vs PY,Change'
     'J1.DWMETRICSDESCRIPTION.PPPYPct' AS 'PP vs PY,Change%'
     'J1.DWMETRICSDESCRIPTION.DBTBLFLAG' NOPRINT
BY &BURST.(<DivisionID,DivisionID>,<DistrictID,DistrictID>,<SchoolID,SchoolID>).Select Burst(sort) order. NOPRINT
BY 'J0.DIM_SCHOOL.DIVISIONID' NOPRINT
BY 'J0.DIM_SCHOOL.DISTRICTID' NOPRINT
BY 'J0.DIM_SCHOOL.SCHOOLID' AS 'School'
BY 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.ORDERID' NOPRINT
BY 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.KEY1' NOPRINT
BY 'J1.DWMETRICSDESCRIPTION.KEY1_DESCRIPTION' NOPRINT AS ''
BY 'J1.DWMETRICSDESCRIPTION.KEY2_DESCRIPTION' AS ''

So I need SUBHEADIN
ON KEY2_DESCRIPTION SUBHEAD
"
The problem is it repeats the subheading again and again for each line because I have couple of hidden sort fields. Is there a way to accomplish this?

[IMG:left]C:\Documents and Settings\Szaidi.CTTLC\Desktop\untitled.bmp[/IMG]

WebFOCUS 7.6.10
Windows
HTML