Print Page - Total mismatch in croos tab report

Title: Total mismatch in croos tab report
Post by: Deeraj on 30 Apr 2009 08:04:31 AM

I have a cross tab report

In Rows i have

cost for growth
sum(cost for growth)
revenue
percentage

Columns
Year

And measures Quarter

the problem is i am getting error in total.
Instead of 10 i am getting 9.

In sum(cost for growth) we have used function (total(currentMeasure within detail [cost for Growth]))

so how 2 solve this..

Title: Re: Total mismatch in croos tab report
Post by: crn.siva on 15 May 2009 03:35:35 AM

Hi Deeraj,

Check the aggregate function property or rollup aggregation property.

Thanks

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Deeraj on 30 Apr 2009 08:04:31 AM