I have created a field called Specialty groups (in the load script) which contains a number of units within it. How do I create a formula to just bring through one of the specialty groups in my analysis?
E.g. Specialty Groups = Surgical, Medical, Paediatrics, Mental Health. I only want to bring through data for 'Medical'. If I use Speciality Groups = 'Medical' it will bring through medical but group all the others into a separate column.
