Sorting a Crosstab not working and Top/Bottom N Rank not working
I had a simple report that I converted to a cross tab. In the original report I had a descending sort on a numeric field and an Advanced Function Top/Bottom N Rank Field that limited the display to 10 records. When I converted it to a crosstab the sort feature is gone, i cannot locate it, and it ignores the Top/Bottom N Rank field completely. how do i get it to work both for sorting and limiting the top 10 records?