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

Report Studio: crosstab col

Started by Maple, 30 May 2007 02:19:25 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Maple

30 May 2007 02:19:25 PM
How to calculate the difference of two columns in crosstab report

MDXpressor

#1
30 May 2007 11:25:55 PM
hmmm.  This may be a trick question, but I will play along...

Creating a new data item (col3) with a definition of col1-col2 doesn't work?

What happens when you use this calc?  What is your data source, i.e. Relational, Dimensional?
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

Maple

#2
31 May 2007 09:33:45 AM
Dimensional

MDXpressor

#3
31 May 2007 12:49:31 PM
make sure the solve order on col3 is set to a higher numer than that of col's 1&2.  You will find solve order in the properties pane of the col3 header.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

Maple

#4
31 May 2007 01:26:53 PM
No this is not working...
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite