Hi,
I am using cognos 10.
I have a requirement of grouping and sorting different columns. Out of 6 columns 4 are grouped and sorted. Now there is 5th column, which i need to sort based on given values not the usual ascending and descending sorting. I query i am achieving this via below.
......................
.............order by empName, case
when country = 'India' then 1
when country = 'America' then 2
when country = 'Bangladesh' then 3
end
So always i want the sort order as India first, America 2nd and Bangladesh 3.
I want to achieve similar on the 5th column on the report. Does anyone faced this kind of situation?