how it works?

[#1]

Hi experts,

pls expain me this ,

=$(=SubField(concat(distinct Dimension,  '|'), '|', 1))

[rwunderlich]

I would suggest you read up on each function in the Help. Then put each piece of the expression into a text box to observe the results. For example, first start with:

=concat(distinct Dimension,'|')

And then add the subfield around it and so on.

-Rob

[#3 · Accepted solution]

thanks rob

with ur motivation i did  same and i understood how it works