Database Reference
In-Depth Information
10.
Close the
IBM Cognos Viewer
window to return to IBM Cognos Report Studio.
We will showcase two ways of correcting this problem in Steps 3a and 3b.
Step 3a: Fix the Crosstab Total Percentage Calculation
1.
Click on the
% of Plan
column heading to select it.
2.
In the
Properties
pane, change the
Solve Order
property from a blank value to
2
.
By default, all the data item properties do not have this property set.
Solve Order property indicates which values will be calculated first in crosstabs and
charts. The items with the lowest sort order values are calculated first; otherwise, the
calculations on the detail rows are performed first, and then all the summaries.
The percentage calculation column should be calculated last, and since the summaries
of the Revenue and Projected Revenue will already exist, the report server will use them
to calculate the overall Year percentage.
3.
From the
Run
menu, select
Run Report - HTML
to view the report. The report results
should look similar to Figure 1.17.
Figure 1.17
Final crosstab view
Notice how the Total line for the percentage calculations is now correct.
4.
Close the
IBM Cognos Viewer
window to return to IBM Cognos Report Studio.
Step 3b: Try an Alternative Solution
There is actually an easier and quicker way to achieve the same result. Instead of task 8 in Step 2,
do the following simple task:
1.
From the
To o l b a r
, click on the
Summarize
button and select the
Automatic Summary
option.