Two columns totaling

Hi Experts,

I need a help regarding the query three colums total and again query should continue example

SECTOR(ex AGRO) | SECTOR(ex Invst)

COMPCDE1| COMPCODE2| TOTAL| COMPCODE3|

COMPNCODE4| TOTAL|

Can any one share how to go abt this i knew we can use only 2 structures per query. sector is having many company codes for ex AGRO sector(company code 1 to 4) Sector Invst(company code 6 to 10) and i have put GL account in a row with hier reporting can any one share how to go abt this totals.

Thanks a bunch in advance

Reg

Ram