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!
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!