Sales Rep full Name: CONCAT({employee.firstname}, CONCAT(‘ ‘,{employee.lastname}))
Month Wise Sort:
CONCAT(
CASE TO_CHAR({trandate}, ‘MM’)
WHEN ’01’ THEN ‘a. ‘
WHEN ’02’ THEN ‘b. ‘
WHEN ’03’ THEN ‘c. ‘
WHEN ’04’ THEN ‘d. ‘
WHEN ’05’ THEN ‘e. ‘
WHEN ’06’ THEN ‘f. ‘
WHEN ’07’ THEN ‘g. ‘
WHEN ’08’ THEN ‘h. ‘
WHEN ’09’ THEN ‘i. ‘
WHEN ’10’ THEN ‘j. ‘
WHEN ’11’ THEN ‘k. ‘
WHEN ’12’ THEN ‘l. ‘
END,
‘ ‘,
RTRIM(TO_CHAR({trandate}, ‘MON’)),
‘ ‘,
TO_CHAR({trandate}, ‘YYYY’)
)