LOV's in filter not in order

Hi ALL,

When i run my webi report with month.cal in webi...the dates do not sort as they do in BEX.

it shows 12.2009 is greater than 01.2010. so i had to create a variable write a formula to fix this in webi.

but when user choses month .cal as a Report filter in webi report users see that the dates are not sorted properly.

How do i get this done.

Thanks

Edited by: pali1010 on May 24, 2010 9:09 PM