Implement PIVOT Table in Oracle 11g

You need to pivot the result.

Refer below link.

https://www.oracle.com/in/technical-resources/articles/database/sql-11g-pivot.html

My data in table

Script

WITH cte_month AS
 (SELECT row_number() OVER(PARTITION BY to_char(r.balance_date, 'Month'), to_char(r.balance_date, 'Year') ORDER BY balance_date DESC) row_num,
         arrears_in_days,
         balance_date,
         acct_id
    FROM report r
   where r.acct_id = '11002140008598'
     and (to_char(r.balance_date, 'D')) not in (6, 7))

 SELECT * FROM
(
  SELECT arrears_in_days, balance_date
  FROM cte_month
  WHERE row_num = 1
)
PIVOT
(  
  count(arrears_in_days)
  FOR balance_date IN ('30.11.2021','31.12.2021','31.01.2022','28.02.2022','31.03.2022','29.04.2022','31.05.2022','30.06.2022')
)

Here I want show value from table. But the result I got it different:

Here I show each value by date. My requirement result in below:

RPA says:

count(arrears_in_days)

Use Max function.

MAX(arrears_in_days)