I am wanting to drilldown on a subtotal. Problem is, I have two subtotals and I cannot determine which subtotal line I am on when I do the drill down. Can anyone tell me how to determine which subtotal line I am on?

Here is some simple code I put together for a test.

TABLE FILE V_TEST_FOR_FOCALPOINT
SUM
UNITS
DESCRIPTION
BY MODEL
BY SERIES
BY YEAR

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EXPANDBYROW ON
ON TABLE NOTOTAL

ON TABLE SUBHEAD

"TEST FOR USERS"
""
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=HEADING,
SIZE=9,
JUSTIFY=CENTER,
STYLE=BOLD,
$

TYPE=SUBTOTAL,
COLUMN=UNITS,
TARGET=_blank,
FOCEXEC=unit_report (UNITS=UNITS),
$

TYPE=DATA,
COLUMN=UNITS,
TARGET=_blank,
FOCEXEC=unit_detail_rpt (UNITS=UNITS),
$


ENDSTYLE
END

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

I don't see any SUBTOTALs in the request (maybe they automatically occur for accordion reports)... but the syntax to styling subtotals is:

How to Identify a Grand Total, Subtotal, or Subtotal Calculation
TYPE=type, [BY=sortfield] [coltype=column]

type
Identifies a subtotal or total. Select from:

GRANDTOTAL which is a grand total (generated by COLUMN-TOTAL, SUBTOTAL, SUB-TOTAL, RECOMPUTE, or SUMMARIZE). See Identifying a Grand Total for an example.

SUBTOTAL which is a subtotal (generated by SUBTOTAL, SUB-TOTAL, RECOMPUTE, or SUMMARIZE). See Identifying Subtotals for an example.

RECAP which is a subtotal calculation (generated by ON sortfield RECAP or ON sortfield COMPUTE). See Identifying a Subtotal Calculation (RECAP/COMPUTE) for an example.

BY
If you have a request with multiple BY fields, and two or more have subtotal commands associated with them, you can identify each field using the BY identifier. This is helpful when you want to format each subtotal differently or when you want to format only one subtotal.

You only need to include the BY identifier if you have multiple BY fields in your request.

...

It works. Thx