I have created a new group All which has two values 'Y','N'. While displaying the column in the answer it by default put the All values at the end, event I tried to sort it will just sort Y and N value but not All. I do not see any options to sort the new group in selection steps. Any ideas.
I do not see order by clause in the selection steps when creating the new group. There is only one group All which has two values Y and N. So when the report is run the column shows three values Y, N and All and now able to sort with new group at the top. Sorting in the answer will sort just Y , N.