Top N in Cross Tab base on Column

I have using Cross Tab in my report. The column is the Activities. The rows is the user name. The row will show the number of time the user attend those activities. How i can create a top N to show which activities has the most attendance?开发者_Go百科 Please help. Thanks

If you want to leave the Cross-Tab you have alone, then my suggestion would be to just add another Cross-Tab to the same report section that only has every activity summarized by row as counts of attendees. You could then restrict that CT to only show the Top-2 activities (By going to Group Sort Expert -> Sort by Top N -> N=2). You could even suppress the fields you don't want to show and hide the grid lines so that only the top 2 activities are actually spelled out.

An alternative is to pivot your original CT so that each row was an activity instead of a user, and then sort by the attendance in descending order. This would make it obvious which activities were the top 2.