Postgres 14

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

CREATE TABLE tbl (id text, type int, c1 int, c2 int, c3 int);
    
INSERT INTO tbl (id, type, c1, c2, c3) VALUES
  ('a', 0,   10, 10,   10)
, ('a', 0,    0, 10, NULL)
, ('a', 0,   50, 10, NULL)
, ('c', 0, NULL, 10,   20)
, ('c', 0, NULL, 10, NULL)
;
5 rows affected

WITH total AS (
  SELECT 'total'::text AS id, 0 AS type
       , sum(c1) AS s1, sum(c2) AS s2, sum(c3) AS s3  -- more ...
  FROM   tbl
  )
TABLE tbl

UNION ALL  
TABLE total

UNION ALL
SELECT 'cumulative', 0, a[1], a[2], a[3]  -- more ...
FROM  (
   SELECT ARRAY(
      SELECT sum(v.s) OVER (ORDER BY rn)
      FROM   total
           , LATERAL (VALUES (1, s1), (2, s2), (3, s3)) v(rn, s)  -- more ...
      )::int[] AS a
   ) sub
;


id
type
c1
c2
c3


a
0
10
10
10

a
0
0
10
null

a
0
50
10
null

c
0
null
10
20

c
0
null
10
null

total
0
60
50
30

cumulative
0
60
110
140


-- Works in pg 9.1 too:
WITH total AS (
  SELECT 'total'::text AS id, 0 AS type, sum(c1) AS s1, sum(c2) AS s2, sum(c3) AS s3
  FROM   tbl  -- cloud10k.dash_reportcard
)
TABLE tbl  -- cloud10k.dash_reportcard

UNION ALL  
TABLE total

UNION ALL
SELECT 'cumulative'::text, 0, a[1], a[2], a[3]  -- more ...
FROM  (
   SELECT ARRAY(
      SELECT sum(v.s) OVER (ORDER BY rn)
      FROM  (
         SELECT row_number() OVER (), s
         FROM   unnest((SELECT ARRAY[s1, s2, s3] FROM total)) s  -- more ...
         ) v(rn, s)
      )::int[] AS a
   ) sub
;


id
type
c1
c2
c3


a
0
10
10
10

a
0
0
10
null

a
0
50
10
null

c
0
null
10
20

c
0
null
10
null

total
0
60
50
30

cumulative
0
60
110
140

id	c1	c2	c3
a	10	10	10
a	0	10	null
a	50	10	null
c	null	10	20
c	null	10	null
total	60	50	30
cumulative	60	110	140