Learner evaluation report

Summary:

Content (please ensure you mask any confidential information):

Hi Team,

I have created learner evaluation report where in I want each question text to be a column:

I was able to achieve the results but in the above manner, I want to group the data and added the aggregation logic of max at the rows but its still not working.

If I am adding the below code in question formula then its working fine except for the last field which is CLOB:

MAX(CASE "Learning Evaluations"."Question Text" WHEN 'What part of the course did you find most useful and interesting?' THEN "Learning Evaluations"."Answer Text" ELSE NULL END)