Hi,

There is a small requirement which I'm looking to display the custom text along with the by field value in a single excel cell. So, I have a tabular data with subfoot showing totals at division and department level. The data looks like the below.

  
  
  DIVISION   DEPARTMENT    SALES    COST 
  =======================================
  HR           HRD          $1000    $500
  HR           HRD          $1000    $500
  PR           HRD1         $1000    $500
  PR           HRD2         $1000    $500

The output should be in Excel, with subtotals shown whenever the division get changed. For example my expected output should be like below.

  
  
  DIVISION   DEPARTMENT    SALES    COST 
  =======================================
  HR           HRD          $1000    $500
  HR           HRD          $1000    $500
[B]TOTAL HR                 $2000    $1000 [/B]
  PR           HRD1         $1000    $500
  PR           HRD2         $1000    $500
[B]TOTAL PR                 $2000    $1000 [/B]

The above can be achieved using subfoot but the "TOTAL" text along with field value in EXL2K should come in a single Cell. right now the "TOTAL" is coming in one cell and Field value here "HR/PR" going to second cell of the sheet when tried to show in the single Cell.

My ask is is there anyway to bring both the Field value and custom text in a single cell. Here the case is "TOTAL HR" something like this. Please let me know

Thank you!

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

Just use SUBTOTAL.

(And you posted this to the wrong area)

(and Bold and other formatting tags do not work within the scope of Code tags.)

Wrong sub forum to post technical question. Should post to Webfocus/FOCUS Forum.

...
ON DIVISION SUBTOTAL
...
ON TABLE SET STYLE *
...
TYPE=SUBTOTAL, STYLE=BOLD, $
...
END