Professional > Data management scripting > Publishing data > Cognos Framework Manager models > Building simple reports in Cognos Report Studio > Creating reports for grid questions > Presenting measure as a percentage based on the total row values
 
Presenting measure as a percentage based on the total row values
This section details the process of updating properties for the Serial measure in order to generate percentage values based on the total row values.
1 Update the following Serial measure properties:
Change the Expression value to:
Count([rating].[Dimensions].[Serial]) / total( (count([rating].[Dimensions].[Serial])) For ([LevelID]) )
Change the Aggregate Function value to:
Calculated.
2 Update the Measure display format by left-clicking the data column, selecting Data Format in the Properties panel, and clicking the ellipsis button. This displays the Data Format dialog.
3 Change the Format type to Percent and then change the Percentage Symbol value to %.
Result
The report is rendered as:
Serial
Not at all interested (1)
Not particularly interested (2)
No opinion (3)
Slightly interested (4)
Very interested (5)
Dinosaurs
3.88%
0.39%
10.47%
43.80%
41.47%
Conservation
5.36%
3.57%
12.50%
53.57%
25.00%
Fish and reptiles
5.41%
4.50%
25.23%
40.54%
24.32%
Fossils
9.23%
1.54%
23.08%
38.46%
27.69%
Birds
9.57%
8.51%
19.15%
34.04%
28.72%
Insects
16.46%
2.53%
22.78%
34.18%
24.05%
Whales
2.44%
 
17.07%
34.15%
46.34%
Mammals
2.90%
2.17%
18.84%
39.86%
36.23%
Minerals
15.12%
6.98%
16.28%
29.07%
32.56%
Ecology
10.71%
 
17.86%
35.71%
35.71%
Botany
20.00%
5.45%
23.64%
25.45%
25.45%
Origin of species
3.92%
3.92%
15.69%
28.43%
48.04%
Human biology
3.25%
4.07%
13.82%
27.64%
51.22%
Evolution
10.26%
1.71%
15.38%
35.04%
37.61%
Wildlife in danger
 
3.12%
6.25%
50.00%
40.62%
See also
Building simple reports in Cognos Report Studio