Print Page - Problem with crosstab total

Title: Problem with crosstab total
Post by: jahnavi on 14 Dec 2010 06:20:24 AM

Hi Gurus,

I am facing a problem like in my report there is area,division,manager and I am displaying the last 3 months, priot 3 months ,and the calculation ((last 3 months/prior 3months)-1)*100 against this. I am facing the problem in this calculation
the calculation is fine in all the individual column wise. But I am facing the problem in the footer its is coming as total. But I need this as the calculation above

Please please do help me on this

Thanks,
Jahnavi

Title: Re: Problem with crosstab total
Post by: MFGF on 14 Dec 2010 10:26:40 AM

Change the Rollup Aggregate property to 'Calculated'. That should do the trick.

MF.

Title: Re: Problem with crosstab total
Post by: jahnavi on 14 Dec 2010 11:29:48 PM

Thanks for the reply.

I tried in that way as well but didnt worked. Can you suggest some other alternative

Thanks,
Jahnavi

Title: Re: Problem with crosstab total
Post by: MFGF on 15 Dec 2010 10:19:32 AM

How did you add the footer(s)? Did you use the Aggregate button on the toolbar or have you added them as Query Calculations?

MF.

Title: Re: Problem with crosstab total
Post by: jahnavi on 20 Dec 2010 04:22:06 AM

Hi,

The issue got resolved by writing the following maximum(calculation for [area],[division],[region])

Thanks For the support and Help

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jahnavi on 14 Dec 2010 06:20:24 AM