Using data as a grouping

[tommyl]

Hello,

I have below "Customer Table":

Segment	Customer ID
SME	12345
SOHO	12346
SOHO	12347
INDIVUDUAL	12348
SOHO	12349

And a "configuration table" like: 

Segment Name

SOHO

SME

INDIVIDUAL

Segment Names are alterable/ dynamic (new segment name can be added to this table). 

I need to count the customer's by segment name but in the set expression i don't want to write this hardcoded:

count(distinct(({$<segment={'SME'}>}customerid)).

I need to take the segment names(above set expression 'SME' value) from the configuration table. Is there a way to do this? 

Thank you

[Gysbert_Wassenaar]

I think that when loading the data you should rename the field Segment to Segment Name.

But if you want to do it the complicated way you can try: count(distinct(({$<segment=P([Segment Name])>}customerid))