ReportSQL - Grouping Dispostion into Case and Not Case

A perfect job for a Lookup Transform Index but you can't add the Case Disposition lookup to an index. 🤷

• Text formula field on Case Data
• The lookup value IDs for prescreen, incomplete intake, and rejected should be the same on every site.

case
when
%tableAlias%.case_disposition in (100424, 100423, 100422)
then 'Not Case'
else 'Case'
end