Percent Growth Calculation in Crosstab based on Year selection in Prompt.

[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 :)