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

Total mismatch in croos tab report

Started by Deeraj, 30 Apr 2009 08:04:31 AM

Previous topic - Next topic

Deeraj

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


crn.siva

Hi Deeraj,

Check the aggregate function property or rollup aggregation property.

Thanks