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

Cross tab- need calculation

Started by mathewmvar, 20 Dec 2010 01:43:33 AM

Previous topic - Next topic

mathewmvar

I created a cross tab  report in the report studio.
I need the create a calculated column ( Currrent Year – Last Year).


Item Group   2008   2009   2010   Cu.Year-Last Year      
Item Group1   10   16   75   59      
Item Group2   20   26   12   -4   

In the drill down I expect the following output

1.   When I drill down "item group1"  to items level, it automatically calculate the current year- last year
2.   When I drill down year ( 2010) to month, the output is also change to same, current year- last year.
How I can achieve these result?

Mathew

MFGF

The result for 1 should happen automatically.  What problems are you getting?

MF.
Meep!

mathewmvar

#2
In query, in which insertable object i have to use to calculate the difference between 2 yeas.
If i use "Data Item", i can not apply the conditional style .

How to make the conditional style , if i use "data item" to calculate the difference between 2 years. now all the values coming in the "Missing Values" range of Conditional style .

mathewmvar

hi,

in query, i added a data item and create  calculation to find the difference  between 2 members. But this data item comes as "string"  and i can not apply style condition, because it is string.
How to convert the data item string to number.

Mathew