Dynamic pivot

report error:
ORA-00904: "D"."SALESMAN": invalid identifier

xml pivot

JobANALYSTCLERKMANAGERPRESIDENT
102200
200115
302000
 0010
As described here by fac586 (Paul MacMillan)