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

[solved] Crosstab with Calculation aggregation issue

Started by cavalaxis, 19 Jul 2006 11:25:22 AM

Previous topic - Next topic

cavalaxis

I'm trying to use a calculated text value as a column header.  I'm having a strange aggregation issue.  Is what I'm trying to do even possible?

.Calc1Calc2Calc3
label1----123
label2--456--
label3789----
label4------
label5------
TOTAL789456123

I've set the aggregation property in the model to automatic.  Help?

Thank you,
Lynn

MFGF

Hi Lynn,

I'm not clear what you're trying to achieve here.  Are you looking to reproduce the format included in your message, or are you getting that format but you require something different?

If you can give us some clear details about what you're trying to achieve, that would help.

Best regards,

MF.
Meep!

cavalaxis

My apologies.  The result I displayed was not the result I wanted.

I fixed the problem at the Model level by adding the calculation to a passthrough query.   Thanks for your help anyway.