how do i AGGR this string?

[amien]

Amien Team045

Amien Team556

i need this pivot

1 dimension 2 expressions:

Amien Team045 Team556

AGGR must be on a wildcard match on 045 and 556 .. not on full string.

[johnw]

I'm not sure if I understand the question, but if I do, one approach is just two expressions:

sum(if(wildmatch(Team,'*045*'),whatever))
sum(if(wildmatch(Team,'*556*'),whatever))

Another would be to add a synthetic dimension across the top (exclude null):

if(wildmatch(Team,'*045*'),'Team045'
,if(wildmatch(Team,'*556*'),'Team556'))

And then just have sum(whatever) as the expression. Replace "sum()" and "whatever" with whatever expression you actually wanted.