pick match

[TomBond77]

Hi experts

I have modified a cyclic dimension, defined inside a button. It worked before very well. Now I had to change the load script, the new field is named [Ansv.Function] with this new field the cyclic dimension doesn't work. 

=pick( match('$(vDimension)', 'Konto', '[Ansv.Function]', 'Kontogrupp' ),'Kontogrupp','Konto', 'Function' )

When it comes to 'Function' the button shows a "-":

Any ideas why this logic is not working anymore?

Thanks, Tom

[rubenmarin]

Hi, try adding a text object or table with $(vDimension) as measure to cehck the value it returns when function dimension is selected, and use this value in the match function.