Problem with crosstab total

[jahnavi]

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

[MFGF]

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

MF.

[jahnavi]

Thanks for the reply.

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

Thanks,
Jahnavi

[MFGF]

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.

[jahnavi]

Hi,

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

Thanks For the support and Help