Scramble the dimension value in a bar when selected from a list box

[Manish]

Hi All

I want to hide the dimension's value in a bar chart when selected from "Peers" List box and show as it is when selected from "Clients"List box.

For example : If I select "Rob" in "Clients" listbox and "Pat" and "Glenn" in "Peers" list box then 

X-  Axis of a bar chart should have dimension values as Rob, Client PXXXX , Client GXXXX

See attached application.

I tried below cal. dimension but no luck. 

If(Wildmatch(GetFieldSelections(ClientName,';','','ScrambledClientName'),'*' & ClientName & '*'),
'Client ' & Left(ClientName,1) & 'XXXX',
ClientName
)

Please help.

[Manish]

Hi ,

I got the result I am looking for.

=Aggr(Only(If(Wildmatch(GetFieldSelections(ClientName,',','','ScrambledClientName'),'*'&ClientName&'*'),
Dual(Left(ClientName,1) & 'XXXX',ClientName),
ClientName
)),ClientName
)

Still if you guys think there is better way to achieve it , please feel free to share.

Thanks