Is it possible to exclude a child in the output when using the hierarchy to drive the output?

For example with this code:

SET FORMULTIPLE = ON
JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF
TABLE FILE CENTGL
SUM
NAT_AMOUNT/D10.0
NAT_YTDAMT/D10.0
FOR GL_ACCOUNT
2000 GET CHILDREN 1 ADD AS CAPTION OVER
BAR OVER
2000 ADD AS CAPTION    LABEL GROSS   OVER
BAR OVER
3000 GET CHILDREN 2 ADD AS CAPTION OVER
BAR OVER
3000 ADD AS CAPTION  LABEL EXP OVER
BAR AS = OVER
RECAP TOTAL = GROSS + EXP; AS 'TOTAL'
IF PERIOD EQ '2002/03'
END  

The output is:

 
PAGE 1 
 

                  Month Actual    YTD Acutal                                  
Revenue            -10,398,305.  -30,877,546. 
Cost Of Goods Sold   5,884,646.   17,796,997. 

Gross Margin        -4,513,659.  -13,080,549. 

Selling Expenses     1,554,319.   4,451,098. 
Advertising          1,303,277.    3,705,368. 
Promotional Expenses    53,719.      151,732. 
Joint Marketing         97,135.      289,799. 
Bonuses/Commisions     100,188.      304,199. 
General + Admin Exp  1,838,005.    5,241,198. 
Salaries-Corporate     771,513.    2,202,738. 
Company Benefits       502,550.    1,409,047. 
Depreciation Expenses  155,231.      467,564. 
Gain/(Loss) Sale of Eq -19,048.      -58,887. 
Leasehold Expenses      11,946.       30,345. 
Interest Expenses       85,420.      240,793. 
Utilities              330,393.      949,598. 

Tot Op Expenses      3,392,324.    9,692,296. 

TOTAL               -1,121,335.   -3,388,253. 
 

Is there a way to code exclusion of the Advertising line?

Bethany

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

Have you tried Where GL_ACCOUNT NE 'Advertising' ?

Unfortunately, I need to exclude it from one section and then include it in another.

Where do you want to excluse it from ?

In this example, I'd want to exclude Advertising from Selling Expenses and then include it in General + Admin Expenses instead.