Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (status, user_type) AS
  SELECT 2, 1 FROM DUAL CONNECT BY LEVEL <=  3 UNION ALL
  SELECT 4, 1 FROM DUAL CONNECT BY LEVEL <= 13 UNION ALL
  SELECT 5, 1 FROM DUAL CONNECT BY LEVEL <=  1 UNION ALL
  SELECT 3, 1 FROM DUAL CONNECT BY LEVEL <=  5 UNION ALL
  SELECT 3, 5 FROM DUAL CONNECT BY LEVEL <=  1 UNION ALL
  SELECT 0, 1 FROM DUAL CONNECT BY LEVEL <=  4 UNION ALL
  SELECT 0, 5 FROM DUAL CONNECT BY LEVEL <=  8;
35 rows affected

SELECT CASE GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END)
       WHEN 0
       THEN TO_CHAR(status)
       WHEN 2
       THEN 'SUB-TOTAL'
       ELSE 'TOTAL'
       END AS status,
       COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1",
       COUNT(CASE user_type WHEN 2 THEN 1 END) AS "2",
       COUNT(CASE user_type WHEN 3 THEN 1 END) AS "3",
       COUNT(CASE user_type WHEN 5 THEN 1 END) AS "5",
       COUNT(*) AS total
FROM   table_name
GROUP BY CUBE(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END)
HAVING GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) IN (0, 3)
OR     (   GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) = 2
       AND CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END = 1 )


STATUS
1
2
3
5
TOTAL


0
4
0
0
8
12

3
5
0
0
1
6

2
3
0
0
0
3

4
13
0
0
0
13

5
1
0
0
0
1

SUB-TOTAL
17
0
0
0
17

TOTAL
26
0
0
9
35


SELECT TO_CHAR(status) AS status,
       COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1",
       COUNT(CASE user_type WHEN 2 THEN 1 END) AS "2",
       COUNT(CASE user_type WHEN 3 THEN 1 END) AS "3",
       COUNT(CASE user_type WHEN 5 THEN 1 END) AS "5",
       COUNT(*) AS total
FROM   table_name
GROUP BY status
UNION ALL
SELECT 'SUB_TOTAL',
       COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1",
       COUNT(CASE user_type WHEN 2 THEN 1 END) AS "2",
       COUNT(CASE user_type WHEN 3 THEN 1 END) AS "3",
       COUNT(CASE user_type WHEN 5 THEN 1 END) AS "5",
       COUNT(*) AS total
FROM   table_name
WHERE  status IN (2,4,5)
UNION ALL
SELECT 'TOTAL',
       COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1",
       COUNT(CASE user_type WHEN 2 THEN 1 END) AS "2",
       COUNT(CASE user_type WHEN 3 THEN 1 END) AS "3",
       COUNT(CASE user_type WHEN 5 THEN 1 END) AS "5",
       COUNT(*) AS total
FROM   table_name


STATUS
1
2
3
5
TOTAL


2
3
0
0
0
3

4
13
0
0
0
13

0
4
0
0
8
12

5
1
0
0
0
1

3
5
0
0
1
6

SUB_TOTAL
17
0
0
0
17

TOTAL
26
0
0
9
35


SELECT TO_CHAR(status) AS status,
       "1",
       "2",
       "3",
       "5",
       "1" + "2" + "3" + "5" AS total
FROM   table_name
PIVOT ( COUNT(*) FOR user_type IN (1,2,3,5) )
UNION ALL
SELECT 'SUB_TOTAL',
       "1",
       "2",
       "3",
       "5",
       "1" + "2" + "3" + "5" AS total
FROM   (SELECT user_type FROM table_name WHERE status IN (2,4,5))
PIVOT ( COUNT(*) FOR user_type IN (1,2,3,5) )
UNION ALL
SELECT 'TOTAL',
       "1",
       "2",
       "3",
       "5",
       "1" + "2" + "3" + "5" AS total
FROM   (SELECT user_type FROM table_name)
PIVOT ( COUNT(*) FOR user_type IN (1,2,3,5) )


STATUS
1
2
3
5
TOTAL


2
3
0
0
0
3

4
13
0
0
0
13

0
4
0
0
8
12

5
1
0
0
0
1

3
5
0
0
1
6

SUB_TOTAL
17
0
0
0
17

TOTAL
26
0
0
9
35


SELECT title AS status,
       "1",
       "2",
       "3",
       "5",
       "1" + "2" + "3" + "5" AS total
FROM   (
  SELECT l.*, t.user_type
  FROM   table_name t
         CROSS JOIN LATERAL (
           SELECT t.status, TO_CHAR(t.status) AS title, 1 AS priority FROM DUAL UNION ALL 
           SELECT NULL,     'SUB_TOTAL',                2 FROM DUAL WHERE t.status IN (2,4,5) UNION ALL
           SELECT NULL,     'TOTAL',                    3 FROM DUAL
         ) l
)
PIVOT ( COUNT(*) FOR user_type IN (1,2,3,5) )
ORDER BY priority, status


STATUS
1
2
3
5
TOTAL


0
4
0
0
8
12

2
3
0
0
0
3

3
5
0
0
1
6

4
13
0
0
0
13

5
1
0
0
0
1

SUB_TOTAL
17
0
0
0
17

TOTAL
26
0
0
9
35
STATUS	1	5	TOTAL
0	4	8	12
3	5	1	6
2	3	0	3
4	13	0	13
5	1	0	1
SUB-TOTAL	17	0	17
TOTAL	26	9	35
STATUS	1	5	TOTAL
2	3	0	3
4	13	0	13
0	4	8	12
5	1	0	1
3	5	1	6
SUB_TOTAL	17	0	17
TOTAL	26	9	35