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?
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.
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).Ã,Â