SQL> select doc, price,  18  nds,  price_nds, price_with_nds
   2   from (select case when grouping(doc_id)= 0  and grouping(price)= 1 
   3                 then 'Итого РСХ-'||doc_id
   4                 else 'РСХ-'||to_char(doc_id)
   5                end doc,
   6                sum(price) price,
   7                sum(round(price* 0 . 18 , 2 )) price_nds,
   8                sum(round(price* 1 . 18 , 2 )) price_with_nds,
   9                sum(price) over (partition by doc_id) price_doc,
  10                sum(round(price* 0 . 18 , 2 )) over (partition by doc_id) price_nds_doc,
  11                sum(round(price* 1 . 18 , 2 )) over (partition by doc_id) price_with_nds_doc
  12         from (select
  13               case when mod(rownum, 2 )= 0  then rownum- 1  else rownum end doc_id,
  14               round(dbms_random.value* 1000 , 2 ) price
  15               from dual
  16               connect by level<= 30 
  17              ) v1
  18         group by rollup (doc_id,price)
  19        )
  20   where round(price_doc* 1 . 18 , 2 )<>price_with_nds_doc;

DOC                                                     PRICE        NDS  PRICE_NDS PRICE_WITH_NDS
-------------------------------------------------- ---------- ---------- ---------- --------------
РСХ- 17                                                   733 , 76           18       132 , 08           865 , 84 
РСХ- 17                                                    736 , 2           18       132 , 52           868 , 72 
Итого РСХ- 17                                            1469 , 96           18        264 , 6          1734 , 56 

SQL>