Cognos DMR crosstab MTD,YTD % change calculation

[yousuf_248]

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

[Francis aka khayman]

how are you calculating previous MTD value?