APEX

Hello, I'm trying to do a pivot query, but I am getting [unsupported data type], instead of having returning values

here is my query

WITH pivot_data AS (

            SELECT DEPARTMENT,CS_GROUP AS "CS GROUP",CS_GROUP

            FROM  TABLE1  where PER = 'NAB' and department not like 'SD%'          )

   SELECT *

   FROM   pivot_data

   PIVOT XML(

               COUNT(CS_GROUP)

               FOR DEPARTMENT          

               IN  (SELECT DISTINCT DEPARTMENT FROM PIVOT_DATA))

ORDER BY 1

and the return value looks like this

any ideas why this is happening? I am on oracle 11g and apex 3.2.1

Thanks.