Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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