Drop down Selection menu in Dashboards

i have a numbered list with hierarchy, suppose the items in the list are PC-A , PC-B, PC-C, PC-D. When i publish this list in dashboard as page selector, i am seeing PC-A, but the requirement is i should only see A in the drop down.

 

How to do this?

 

Regards,

Adhvi

Tagged:

Best Answer

  • Hi Adhvi,

     

    Truncate "PC-" from the Display Name PC-A.

     

    Try the below logic:

    1. Right(Display Name,1)

    2. Right(Display Name,length(Display Name)-3)

     

    ~Vignesh

Answers