COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Revelator80 on 15 Sep 2010 09:08:17 AM

Title: Moving Annual Total in Cognos 8.4
Post by: Revelator80 on 15 Sep 2010 09:08:17 AM
Hi,

I have a package based on a DMR model and have been requested to deliver a report showing Moving Annual Total by Customer Sector and Month (i.e. Months along the x Axis with the Sectors as the series in a line chart).

My first attempt based off standard MDX syntax was rejected, any ideas?

Cheers
David