Sorting on a column in a cross tab 1

[Hoppkins]

I have a field in a cross tab which is the summary total of another field, i want to sort on this field but cannot see how.

Basically the field just outputs a word and the summary counts how many occurances of the word there are and presents it as a number.

See pic below to see how it appears. I want to be able to sort by the right hand number which is the summary of the cross tab

http://i2.photobucket.com/albums/y44/hoppkins/sort.jpg

http://i2.photobucket.com/albums/y44/hoppkins/sort2.jpg

The 2nd pic shows the setup of the cross tab. Is it possible to sort on the summarised field as opposed to the others?

Thanks

 

[lbass]

Select the crosstab and then go to report->topN/group sort and select "count of {table.description}".

-LB

 

[Hoppkins]

When I go there it just has the first columns field as a selectable sort (Title).

As so, thanks !

http://i2.photobucket.com/albums/y44/hoppkins/sort3.jpg

 

[Hoppkins]

Actually you were right, i wasn't using the TOP N function right!

Thanks!