Hello,

I am having trouble formatting only the SUM columns in an ACROSS Table.

 TABLE FILE PREV_YEAR
SUM
	COLVAL
ACROSS LOWEST DATECALENDARKEY_YEAR_M
BY CATEGORY
BY MEASUREFULLNAME
TYPE=TITLE,
     COLUMN=MEASUREFULLNAME,
     BACKCOLOR=RGB(247 150 70),
$
 

What I want to do is fill in the white space that is next to Category and Measurefullname in the title bar. Not sure if my Picture will show up but if it doesn't here's an example of my table

                         
                            ----------------- ----------------- -----------------
                            DATECALENDARKEY | DATECALENDARKEY | DATECALENDARKEY |
--------- ----------------  ---------------- ----------------  ---------------- |
CATEGORY | MEASUREFULLNAME |     COLVAL     |    COLVAL       |     COLVAL      |
--------- ---------------- |----------------|-----------------|-----------------|
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|      
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|      
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|      
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|      
Category | Measure         |      12        |    21           |         23      |
--------- ----------------- ----------------|-----------------|-----------------|       

I want to be able to conditionally fill in the COLVAL column headers without formatting the CATEGORY or MEASUREFULLNAME BY fields. Does anyone have any idea how to do this? I'm at a loss of what to do here. I have a feeling I need to use a different object reference in my TYPE = TITLE statement but not sure what to do here. I have tried ACROSSVALUE and ACROSSTITLE and neither of those have given me the results that I want.

Thanks in advance!!

This message has been edited. Last edited by: Brandon Andrathy,

Is this something such as this that you are looking for ?

SET ACRSVRBTITL = ON
TABLE FILE CAR
SUM RETAIL_COST AS ''
BY COUNTRY
BY CAR
ACROSS MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TITLE,
     COLUMN=RETAIL_COST(*),
     BACKCOLOR=RGB(247 150 70),
$
ENDSTYLE
END
-RUN

Also, when posting sample result, use the code tag. It will help to have your sample aligned as you wish

Hey Martin,

Thanks for your response. Fixed my sample result.

So when I type in

quote:

TYPE=TITLE,
COLUMN=RETAIL_COST(*),
BACKCOLOR=RGB(247 150 70),
$

The title bar still doesn't fill in. Is this a bug? If I don't have a Column value specified at all, the title bar fills in across the application.

Curious if it's because I have a table with the MORE function. I'm on 8201 right now.

Oh wait!

Once I put

quote:

ON TABLE SET ACRSVRBTITL ON

in the table instead of having it as a global SET, it worked!!

Thanks Martin! Appreciate it.