Print Page - Cognos DMR crosstab MTD,YTD % change calculation

Title: Cognos DMR crosstab MTD,YTD % change calculation
Post by: yousuf_248 on 12 Feb 2014 03:16:48 AM

Hi everyone

Can someone please help me achieve a crosstab which lists say Region in rows and in columns MTD and YTD Sales values and % change in MTD and YTD.

I could achieve MTD and YTD sales values. Also i could get Previous MTD and Previous YTD values for % change calculation.

I am calculating % change like this

(previous MTD- MTD value)/Previous MTD value * 100 but when i pull this column in crosstab it's blank.

I am calculating MTD sales value like this 'total(sales within set MTD) and MTD=Periodstodate(...level...,selected date)

Thanks in Advance

When

Title: Re: Cognos DMR crosstab MTD,YTD % change calculation
Post by: Francis aka khayman on 13 Feb 2014 02:56:22 AM

how are you calculating previous MTD value?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: yousuf_248 on 12 Feb 2014 03:16:48 AM