We are currently at SAP Design Studio 1.6 version. We are not using BW so there is no BEX Query Designer.
We are in need to list last 36 months (March 2016, Feb 2016, etc) on a drop down box and depends on the month selected, data will be displayed on dashboard accordingly. We got the latest month and year value from the source query in universe, but when using the Month dimension in DS dropdown, it didn't sort the month value in chronological order but in alphabetical order instead.
Source query result sorted by Seq_Month_Number Desc :
We need the drop-down box to show the order of the month column.
Is there a way to achieve this in DS?
Thanks in advance for any valuable tip/trick.