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

Crosstab Measure calculated not total

Started by chris2001dc, 20 Mar 2009 09:04:58 AM

Previous topic - Next topic

chris2001dc

Hi,

I am working with Cognos 8.3, I have a calculation in a crosstab and I want the totals to be calculted with the formula expresion but the crosstab aggregates de values.

The picture illustrates what I want.

The measure of the crosstab has this fórmula:
Measure = (Measure1/Measure2) / Factor

Please Help.

Thanks

blom0344

Will the calculated total make any sense if you use division by factor? (which factor anyway)

chris2001dc

hi I used this formula and it worked

Total(current measure within detail [DATE])/[Factor]

Thanks