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

Crosstab - Change over time

Started by Robl, 26 May 2016 11:43:09 AM

Previous topic - Next topic

Robl


I have a crosstab.
It has 6 months on the top and a few measures as rows.
I need to show the change on one of those measures over the months.

Is there a simple way of doing this?
Data source is a simple star schema in SQL Server so I can't use any of the OLAP tricks.

For example.
If the numbers for Jan to April are;
10, 12, 14, 10

I need the change column to show
NA, 2, 2,-4


(My ways all involve convoluted methods involving second joined queries with month-1 calculated in there. Or making the report into a list and doing loads of calculation involving comparing dates).