Additional comments and Reason for joining can't fetch the OTBI report
Summary:
Question test to response answer in Pivot Table format
Content (required):
Formula for Question test
CASE WHEN "Checklist Questionnaire"."Question Text" = 'What is your main reason for leaving?' THEN 'Reason for leaving' WHEN "Checklist Questionnaire"."Question Text" = 'Recruitment process' THEN 'Recruitment process' WHEN "Checklist Questionnaire"."Question Text" = 'Job responsibilities' THEN 'Job responsibilities' WHEN "Checklist Questionnaire"."Question Text" = 'Career Progression' THEN 'Career Progression' WHEN "Checklist Questionnaire"."Question Text" = 'Working Conditions, e.g. the physical working environment and flexibility to work you were given' THEN 'Working Conditions' WHEN "Checklist Questionnaire"."Question Text" = 'Enablement & Engagement Initiatives e.g. GRiP, social events, health campaigns, etc.' THEN 'Enablement_Engagement' WHEN "Checklist Questionnaire"."Question Text" = 'Immediate Management' THEN 'Immediate Management' WHEN "Checklist Questionnaire"."Question Text" = 'Salary and compensation' THEN 'Salary and compensation'