I am creating a report that displays multiple demographics of employees who do or do not utilize direct deposit. One of the groups (UNION_CODE) returns 6 items: (NULL), Union1, Union2, Union3-Service, Union3-Skilled, Union3-Tech and then reports how many in each group has direct deposit, does not have direct deposit, or partially uses direct deposit.
I've been asked to combine the results to show only 3 groups:
2. Union3 (Service, Skilled, & Tech)
3. "Everyone else" ((NULL) and Union2)
Any ideas on how to do this either in the SQL query dataset or in the report layout (or anywhere else)?
SELECT EMPLOYEE, LAST_NAME, FIRST_NAME, DEPARTMENT,
PROCESS_LEVEL, TERM_DATE, SCHEDULE, EMP_STATUS,
UNION_CODE, "COALESCE"(AUTO_DEPOSIT, 'N')
WHERE (TERM_DATE = '01-JAN-1700')