COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Maple on 30 May 2007 02:19:25 PM

Title: Report Studio: crosstab col
Post by: Maple on 30 May 2007 02:19:25 PM
How to calculate the difference of two columns in crosstab report
Title: Re: Report Studio: crosstab col
Post by: MDXpressor on 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?
Title: Re: Report Studio: crosstab col
Post by: Maple on 31 May 2007 09:33:45 AM
Dimensional
Title: Re: Report Studio: crosstab col
Post by: MDXpressor on 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.
Title: Re: Report Studio: crosstab col
Post by: Maple on 31 May 2007 01:26:53 PM
No this is not working...