If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summary in CrossTab is not correct

Started by KarenA, 24 Jul 2006 01:12:34 PM

Previous topic - Next topic

KarenA

I have a crosstab report where I am calculating the total number of items (count), the average cost of those items, and the total cost of those items for each week. (a total of 4 weeks)Ã,  The detail of the report is correct.Ã,  I start to run into a problem on the summary infomation.Ã,  My summary count and my total cost summary are correct.Ã,  My summary average is not what I'm looking for.Ã,  It is totaling all the average weeks - what I want is the total cost summary/total count summary for an overall average.Ã,  How do I do this?

gbahn

Just thought I'd let you know you're not alone on this -- we've got a similar problem, and have had a case open with Cognos since 7/12, with no resolution as yet.

gbahn

Try this -- the problem is probably with the 'Solve Order' property of the crosstab column.Ã,  By default, this is set to zero;Ã,  increase the value to force the overall calculation to happen after other calculations occur (to get to the Solve Order property, select the column header).Ã,Â