select
  nvl(KANAL_DYSTRYBUCJI, 'SUMA CALKOWITA') as KANAL_DYSTRYBUCJI,
  case when KANAL_DYSTRYBUCJI != 'SUMA CALKOWITA'
    then nvl(ROK, 'SUMA')
    else ' '
  end as ROK,
  LICZBA_SZTUK,
  KWOTA
from
(
  select
    CHANNEL_DESC as KANAL_DYSTRYBUCJI,
    to_char(CALENDAR_YEAR) as ROK,
    sum(QUANTITY_SOLD) as LICZBA_SZTUK,
    sum(AMOUNT_SOLD) as KWOTA
  from
    SH.SALES natural join SH.CHANNELS natural join SH.TIMES
  group by
    rollup(CHANNEL_DESC, CALENDAR_YEAR)
) a


select
  nvl(KRAJ, 'ROK') as KRAJ,
  nvl(ROK, 'SUMA') as ROK,
  KWOTA
from
(
  select
    COUNTRY_NAME as KRAJ,
    to_char(CALENDAR_YEAR) as ROK,
    sum(AMOUNT_SOLD) as KWOTA
  from
    SH.SALES natural join SH.CUSTOMERS natural join SH.COUNTRIES natural join SH.TIMES
  group by
    cube(COUNTRY_NAME, CALENDAR_YEAR)
) b