Print Page - crosstab calculations

Title: crosstab calculations
Post by: mprof on 11 Jun 2014 07:55:06 AM

Hi,

I have a crosstab where columns are months (last 6 months)
and the rows are the data (sales)

     June    May     April    March    February
Total Sales   1,516   5,523   5,344   5,577   5,347
Daily Average   151.6   178.2   178.1   179.9   191.0

I want to add additional column that shows the change rate between the current and the last month:

     June May    April    March    February    change rate
Total Sales   1,516   5,523   5,344   5,577   5,347
Daily Average   151.6   178.2   178.1   179.9   191.0   -14.91%

please advise.

Thanks

Title: Re: crosstab calculations
Post by: MDXpressor on 13 Jun 2014 07:36:45 PM

What type of datasource? Cube or relational?

Title: Re: crosstab calculations
Post by: mprof on 15 Jun 2014 12:08:05 AM

relational

Title: Re: crosstab calculations
Post by: MDXpressor on 15 Jun 2014 08:36:53 AM

relational in crosstabs is tricky.

Did you try a column for:

Try (total... for last month) - (total ... for current month)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mprof on 11 Jun 2014 07:55:06 AM