sorting on rows of cross tab

[zakal1983]

Hi,

well, I am trying to sort rows on the cross tab. That should be working without any problem but what I am doing is like

I added a formula field to generate day of week such as "Sunday" , "Monday", and so on because the data is stored in numbers like 1, 2, etc.

Thing is, if I just put numbers for rows on the cross tab, the output is sorted as i wanted. However, if I put the defined formula for rows, the output is random.

Any comments are appreciated.

Thank you
row value1
monday 44
fridy 21
saturday 11
tuesday 14
...


row value1
1 18
2 44
3 14
...

[jade1977]

I do not think that the sorting is random; I think it is alphabetizing it based on the day of the week. What if you just put in the order you have it, then click on the Group Options in the Cross Tab Expert, and tell it to sort by specified order. Hope that helps.