How to give Label name for variable in drill down

[Rajkumar]

Dear all,

How to give  label name for variable in drill down ?

kindly help.

[TimvB · Accepted solution]

It is not possible to give a label name to a drill-down dimension that includes a variable.

I would recommend just changing the field names in the script.

For example: 

Rename Field WeekName to [Week name];

However, the following workaround is possible in the front end:

1. Create a regular dimension and use this as dimension expression:

=$(=Pick(If(GetSelectedCount(WeekName)=0,'1',If(GetSelectedCount(Product)=0,'2','3'))
,'WeekName' //1
,'Product' //2
,'$(vaccountcluster)' //3
))

2. For the label, use the following expression:

=Pick(If(GetSelectedCount(WeekName)=0,'1',If(GetSelectedCount(Product)=0,'2','3'))
,'Week Name' //1
,'Product Name' //2
,'Label Name' //3
)

You can also make the 'Label Name' variable.

Hope it helps.