OTBI Report showing result in multiple rows
We are looking to create a report for Fusion Learn where the columns will contain the questions and a single row will have response for each of the questions answered by a Learner. But in the output we are getting responses in individual rows rather than all being in a row and in respective column. Please refer the image and suggest how we can fix this issue.
For the columns we have used Formulas as
CASE WHEN "Learning Evaluations"."Question Text" = 'I am satisfied with the training facility (venues, rooms etc.).' THEN "Learning Evaluations"."Response List LongText" ELSE '' END