I am looking for a formula that will automatically segregate the dimension values I need. I shared a screenshot of the below to help explain what I am looking for. The dimension is the TECH_ID1 field and I am looking to only have those that start
with "M" followed by four digits. Like "M0101" (shown below). Since each tech Id has a different set of four unique digits, the only common letter is the M at the prefix. Unfortunately the data set is much bigger than below so it would take some time to select all the right ID's. Is there a way to only select the ID's that start with M? Thanks!