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?





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)