Hi,

I have few fields which needs to be displayed in a specific format. Example, Category name should be displayed in the sub-heading under Sub-Category field and subtotoal for category field.

Pls tell how to achieve this.

Thanks

Praveen

This message has been edited. Last edited by: Kerry,

Praveen,

Show us what you want. Set out the layout and put it between the CODE tags (press the right-most icon).

Do you have a format of the fields that you have to display??

Hi Danny,

Thanks for the response.

Here is the format mentioned below.

Sub_Category Metric

sub Heading Category1

Sub_category1 50
sub_category2 100

Sub Total(for Category) 150

sub Heading Category2

Sub_category1 75
sub_category2 90

Sub Total(for Category) 165

Can you pls suggest the way to do..

Try this:

-* File praveen01.fex
TABLE FILE CAR
SUM 
     SALES
BY  COUNTRY NOPRINT 
BY  CAR
     
ON COUNTRY SUBHEAD
"Country: <COUNTRY "
ON COUNTRY SUBTOTAL AS SubTotal
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END