sqlplus compute sum subtotal

Oracle 9.2.0.7 on linux

I thought this should be simple (and perhaps, indeed, it is), but I’m not
getting it.



I want a sum of the invoice amount when the category changes.

e.g., I don’t want the individual account details;

I just want a total for LEGAL, a total for RENTALS, etc.



Any help??

thanks!  Barb



break on report on cg_category_group_name

compute sum label "Sub-Total" of invoice_amt on cg_category_group_name

compute sum of invoice_amt grand_total on report



SELECT  ccd.cg_category_group_name,

        f.acct_key, f.invoice_amt

 FROM workorder_fact f,  class_category_dim ccd

WHERE

 ccd.CC_CLASS_CAT_SID=f.CLASS_CAT_SID

group by

ccd.cg_category_group_name, f.acct_key,f.invoice_amt



CG_CATEGORY_GROUP_NAME      ACCT_KEY INVOICE_AMT

------------------------- ---------- -----------

LEGAL                       93815400        16.6

                            96966321         120

                            97354224         186

                            97354224         202

                            99486321          82

.  .  .  .  .  .  .  .

*************************            -----------

Sub-Total                              104976.06



RENTALS                     13790000       21.52

                            18970000          29

                            18970000       50.12

                            40180000          22

                            40180000        17.6

.  .  .  .  .  .  .  .

*************************            -----------
Sub-Total

Barb Baker
Denver Newspaper Agency
303-954-5384

Other related posts: