Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos8 Crosstab Calculation Issue

Status
Not open for further replies.

JennieO

Programmer
Feb 8, 2008
1
US
I have a crosstab report that looks like this. It is in Report Studio using Cognos 8.

Week 1 Week 2 Week 3 Week 4 Total Month
Acct# Name 50 60 70 80 260
% to Total Month 19% 23% 27% 31%
Acct# Name 30 40 50 60 180
% to Total Month 17% 22% 28% 33%
Grand Total 80 100 120 140 ????
% to Grand Total 18% 23% 27% 32%

My problem is when I added the % to Grand Total line it made the Grand Total disappear under the Total Month (where there are ????). Why would it do that and how do I get it back?

Thanks!

 
No idea why the total disappears.
Did try to enforce the scope to the whole report by defining:

Code:
total([measure] for report)

Where measure is the fact displayed in the body of the crosstab

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top