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… Continue reading Workbook Pivot Formula