Simple beast mode - two case statements inc IN wildcard
I've hit a roadblock on a very simple beast mode I'm trying to create. I wish to sum a value based field based on two filters, one of which has a wildcard required, due to messy data (to be fixed at a later date). Where I've got to is: SUM(CASE WHEN `Budget Segment` IN ('%REL%','%SMB%') AND `Advertising Line` = 'Non…