Filters won't work, you'll need to create the group. What I mean in step 3 is:
Insert the Text1 field into the view. Go to the Add A column start to type Text1 to insert the field. Then right click on the field and choose "Custom Fields". Enter the formula into the field.