Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table original (
 nome, central, grupo, tstamp, yr, quarter, totaloc, totalocnp 
) as
select 'PTLR', 'LR', 'G1', systimestamp, 2019, 1, 3, 1 from dual union all  
select 'PTLR', 'LR', 'G2', systimestamp, 2019, 1, 1, null from dual union all  
select 'PTLR', 'LR', 'NA', systimestamp, 2019, 1, null, null from dual union all  
select 'PTLJ', 'RJ', 'G1', systimestamp, 2019, 1, 2, 1 from dual union all  
select 'PTLJ', 'RJ', 'G2', systimestamp, 2019, 1, 1, null from dual union all  
select 'PTLJ', 'RJ', 'G3', systimestamp, 2019, 1, 4, 3 from dual union all  
select 'PTLJ', 'RJ', 'NA', systimestamp, 2019, 1, null, null from dual union all  
select 'PTLN', 'SN', 'G1', systimestamp, 2019, 1, 5, 5 from dual union all  
select 'PTLN', 'SN', 'G2', systimestamp, 2019, 1, 4, 3 from dual union all  
select 'PTLN', 'SN', 'G3', systimestamp, 2019, 1, 2, 1 from dual union all  
select 'PTLN', 'SN', 'G4', systimestamp, 2019, 1, 3, 3 from dual union all  
select 'PTLN', 'SN', 'NA', systimestamp, 2019, 1, null, null from dual union all 
select 'PTLR', 'LR', 'G1', systimestamp + 60, 2019, 2, 3, 3 from dual union all  
select 'PTLR', 'LR', 'G2', systimestamp + 60, 2019, 2, 1, 1 from dual union all  
select 'PTLR', 'LR', 'NA', systimestamp + 60, 2019, 2, null, null from dual union all  
select 'PTLJ', 'RJ', 'G1', systimestamp + 60, 2019, 2, 1, 0 from dual union all  
select 'PTLJ', 'RJ', 'G2', systimestamp + 60, 2019, 2, 0, 0 from dual union all  
select 'PTLJ', 'RJ', 'G3', systimestamp + 60, 2019, 2, 4, 3 from dual ;  
18 rows affected

select 
  nome, central, yr, quarter, sum( totaloc ), sum( totalocnp ) 
from original
group by rollup( nome, central, yr, quarter ) ;


NOME
CENTRAL
YR
QUARTER
SUM(TOTALOC)
SUM(TOTALOCNP)


PTLJ
RJ
2019
1
7
4

PTLJ
RJ
2019
2
5
3

PTLJ
RJ
2019
null
12
7

PTLJ
RJ
null
null
12
7

PTLJ
null
null
null
12
7

PTLN
SN
2019
1
14
12

PTLN
SN
2019
null
14
12

PTLN
SN
null
null
14
12

PTLN
null
null
null
14
12

PTLR
LR
2019
1
4
1

PTLR
LR
2019
2
4
4

PTLR
LR
2019
null
8
5

PTLR
LR
null
null
8
5

PTLR
null
null
null
8
5

null
null
null
null
34
24


select 
  nome, central, yr, quarter
, sum( totaloc )   totaloc
, sum( totalocnp ) totalocnp
from original
group by rollup( ( nome, central ), yr, quarter ) 
order by 1, 2, 3, 4
;


NOME
CENTRAL
YR
QUARTER
TOTALOC
TOTALOCNP


PTLJ
RJ
2019
1
7
4

PTLJ
RJ
2019
2
5
3

PTLJ
RJ
2019
null
12
7

PTLJ
RJ
null
null
12
7

PTLN
SN
2019
1
14
12

PTLN
SN
2019
null
14
12

PTLN
SN
null
null
14
12

PTLR
LR
2019
1
4
1

PTLR
LR
2019
2
4
4

PTLR
LR
2019
null
8
5

PTLR
LR
null
null
8
5

null
null
null
null
34
24

NOME	CENTRAL	YR	QUARTER	SUM(TOTALOC)	SUM(TOTALOCNP)
PTLJ	RJ	2019	1	7	4
PTLJ	RJ	2019	2	5	3
PTLJ	RJ	2019	null	12	7
PTLJ	RJ	null	null	12	7
PTLJ	null	null	null	12	7
PTLN	SN	2019	1	14	12
PTLN	SN	2019	null	14	12
PTLN	SN	null	null	14	12
PTLN	null	null	null	14	12
PTLR	LR	2019	1	4	1
PTLR	LR	2019	2	4	4
PTLR	LR	2019	null	8	5
PTLR	LR	null	null	8	5
PTLR	null	null	null	8	5
null	null	null	null	34	24