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

Filtering time period

Started by cognos05, 12 Feb 2015 10:51:20 AM

Previous topic - Next topic

cognos05

Hi,
I have a crosstab report like the below one

SalesMeasure       2014/Mar  2014/Apr  2014/May   2014/Jun    2014/Jul    2014/Aug   2014/Sep         2014/Oct   2014/Nov        2014/Dec   2015/Jan       2015/Feb

ProductA                 0                0                  0                  0                0            15               34                    0               67                 56              54                  12


Assume this product is only introduced in 2014/Aug.

I want to draw a line chart starting with my data item only from 2014 Aug till current Date

So I have to find the no on the month in which there was a sale started for the last 12 months and then subtract that by 12.

LastPeriods((MuN for currentMonth that is 2015/Feb), (12  Minus no on the month in which there was a sale started))

I want the expression to be know for getting this value no on the month in which there was a sale started

In the above example it would be (12-6) 6 (ie) 2014/Aug on which the sale started and my line chart will have x axis from 2014Aug to 2015 Feb

Thanks,
Nithya