Can we use Pivot dynamically in BIP

Summary:

Hi Experts ,

We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values which is not dynamic.Is there any approach to address this issue.

SQL code:

SELECT *

FROM (

SELECT QCT.NAME

,COALESCE(TO_CHAR(round(qsr.RESULT_VALUE_NUM, 2)), TO_CHAR(qsr.RESULT_VALUE_CHAR), TO_CHAR(qsr.RESULT_VALUE_DATE, 'MM/DD/YYYY')) RESULT_VALUE_NUM

FROM QA_INSPECTION_PLANS_B QIPB

,QA_INSPECTION_PLANS_TL QIPT

,INV_ORG_PARAMETERS IOP

,QA_IP_EVENTS QIE_Inspec --Inspection Details Table

,QA_RESULT_ACTIONS QRA