Using Oracle 11g R2, with APEX 4.2.3, I am trying to take the following cross tab (pivot) built query:
return 'with pivot_data as (
SELECT department_id, job_id, salary
Which works just fine, and add in the comm column and also have the pivot sum and build department_id based columns.. I haven't found any documentation showing how to have multiple columns summed in a pivot query yet.