none
How to sort the dropdown in MDS Excel add-in

    Question

  • Hi,

    I created a column with MDS domain-based.

    For example a column for months.

    User can use the dropdown to select the name of month they want.

    However, the sorting in MDS excel add-in is order by A-Z automatically.

    How do I change the sorting order by the sequence of months?

    Thanks in advance for the help.


    • Edited by VernaC Monday, August 11, 2014 3:55 PM
    Monday, August 11, 2014 3:54 PM

Answers

  • Hi VernaC,

    Values in Filter dropdown list are sorted by A-Z as you mentioned. It is by designed in Excel. MDS Excel Add-in just get data from MDS into Excel, and then use the Filter feature in Excel to filter it.

    In such similiar scenario in Excel, users often add a dummy column with number before the text, and then use the new column to filter data.

    Thanks,
    Jinchun Chen

    Thursday, August 14, 2014 10:11 AM
    Moderator