Is there a way to trim data based on field content?
Other Campaign FYE 2019
Other Campaign FYE 2020
I need to group by Other Campaign but need to remove all information from the FYE and after so that is says only Other Campaign.
I can't wrap my head around it - any help would be appreciated,
Thanks - CS