Using Pick() function at a drill down dimension

[natalia_rodrigues]

Hi Guys,

I need a drill down dimension, that goes from a category to resource name. Category can be 6 different fields from my data set, depending on the value of the variable vKategorie.  My drill down dimension looks like this:

The code for the first field is:

=Pick($(vKategorie),
    Transaktionsklasse,
    if(wildmatch(le,'digital*'), 'DIT', if(le<>'ERGO', le)),
    SAP_Kostenstelle,
    left(Projekt_Name,6),
    Rolle,
    Shore)

I need my first dimension on my hierarchy, beingd defined by the value in vKategorie, and once the user clicks on one item of this categorie (for example Transaktionsklasse), it would be shown the name of the resource related to that category item.  The problem is that, when I clik on a category item, it doesnt make the drill down as expected.

Does anybody knows what am I doing wrong?

[JordyWegman]

Hi Natalia,

Do you have some example data maybe?

Jordy

Climber