I want a dropdown list of dates to display latest to oldest but can't see where I can do that.
We are using 11.0.7 Cognos Analytics. I'm new to Cognos but have IR and relational database experience.
Once you attach a query to the value prompt you should see a "Sorting" row in the properties. Doubleclick on that and you can define the sorting however you want.
Sorry, I'm not getting it, maybe attachment will help, thank you.