Oracle 11g Release 2

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

with tm_task (task_cd, status, due_date) as (
select 'T0001', 'NW', SYSDATE + 1 from dual union all
select 'T0001', 'IP', SYSDATE from dual union all
select 'T0001', 'AG', SYSDATE  from dual union all
select 'T0002', 'NW', SYSDATE - 1  from dual union all
select 'T0002', 'NW', SYSDATE - 2  from dual union all
select 'T0003', 'AG', SYSDATE + 1  from dual
       )
, initial_totals as (
select task_cd
     , status
     , count(*) as totals
     , sum(case when due_date >= trunc(sysdate) + 1 then 1 else 0 end) as future
     , sum(case when trunc(due_date) = trunc(sysdate) then 1 else 0 end) as today
     , sum(case when due_date < trunc(sysdate) then 1 else 0 end) as overdue
  from tm_task
 group by task_cd, status
       )
select task_cd
     , status
     , future
     , today
     , overdue
     , sum(future) over (partition by task_cd) as future_total
     , sum(today) over (partition by task_cd) as today_total
     , sum(overdue) over (partition by task_cd) as overdue_total
  from initial_totals

TASK_CD	STATUS	FUTURE	TODAY	OVERDUE	FUTURE_TOTAL	TODAY_TOTAL	OVERDUE_TOTAL
T0001	AG	0	1	0	1	2	0
T0001	IP	0	1	0	1	2	0
T0001	NW	1	0	0	1	2	0
T0002	NW	0	0	2	0	0	2
T0003	AG	1	0	0	1	0	0