Professional > Data management scripting > Publishing data > Cognos Framework Manager models > Building simple reports in Cognos Report Studio > Sorting on the Mean column
 
Sorting on the Mean column
1 In Page Explorer select LevelID and click the sort button on the button toolbar. You are provided with various sort options.
2 Select the Edit Layout Sorting option. This displays the Sorting dialog.
3 Add Mean to the Sort list, click the sort button, and then click OK.
Result
Running the report displays information that is sorted on the Mean column:
Serial
Not at all interested (1)
Not particularly interested (2)
No opinion (3)
Slightly interested (4)
Very interested (5)
NA (Auto Created)
Mean
Other
 
 
 
 
 
298
 
Botany
11
3
13
14
14
243
3.309
Insects
13
2
18
27
19
219
3.468
Minerals
13
6
14
25
28
212
3.570
Birds
9
8
18
32
27
204
3.638
Fossils
6
1
15
25
18
233
3.738
Fish and reptiles
6
5
28
45
27
187
3.739
Ecology
3
 
5
10
10
270
3.857
Evolution
12
2
18
41
44
181
3.880
Conservation
3
2
7
30
14
242
3.893
Mammals
4
3
26
55
50
160
4.043
Origin of species
4
4
16
29
49
196
4.127
Dinosaurs
10
1
27
113
107
40
4.186
Human biology
4
5
17
34
63
175
4.195
Whales
2
 
14
28
38
216
4.220
Wildlife in danger
 
1
2
16
13
266
4.281
See also
Building simple reports in Cognos Report Studio