LOV Sort in Universe
We have a Variable created in BEx Query for Calender Year/Month and also List of Values (LOV) object come from the Bex Query to the Universe
LOV is working finr, but default the values are in ascending order. Do we have any solution or approach to get these list of values in descedning order. I am looking for some tricks in Universe or in Bex query. I am aware to sort this in Web I reports.
Currently, we get - 2001001, 2001002... 2011001, 2011002..
We expect as - 2011002, 2011001, 2010012, ....., 2001002, 2001001.
Thanks in advance.