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

Percent Growth Calculation in Crosstab based on Year selection in Prompt

Started by Ankita, 30 Oct 2011 04:16:15 AM

Previous topic - Next topic

Ankita

Hi All,

I am facing an issue with Percent Growth Calculation in Crosstab based on Year selection in Prompt.The version of Cognos being used is 8.4.

The requirement is to select a particular year from the Prompt(based on year level of time dimension) and calculate the percent growth of revenue from the previous year.

its like:  Percent growth= (revenue for selected year-revenue for year previous to selected year)/revenue for year previous to selected year.

I have used lag function to find out the previous year member value and also tried with prevmember.

but while calculating revenue for year previous to selected year as tuple(revenue,previous year member),the data is coming correctly in tabular view...but not value is displayed when this data item is dragged as a column in the Crosstab.

Your help will be appreciated...
Thanks in Advance