Print Page - Sum of previous weeks

Title: Sum of previous weeks
Post by: the_xxx on 18 Nov 2007 09:15:58 PM

Hi all,

How can I sum a QueryItem values for previous 10 weeks based on the prompt date. like pick the week from the prompt date and compare againist the weekly data and pick the previous 10 weeks data and sum it up. The problem I see is, if the week is the first week of next year, how can we pick the sum of values of last years weeks data.

thanks in advance
xxx

Title: Re: Sum of previous weeks
Post by: MFGF on 19 Nov 2007 04:56:58 AM

Hi,

What kind of package are you using - relational (query subjects and query items) or dimensional (dimensions, hierarchies, levels, members, attributes)? The solution will be radically different for each.

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: the_xxx on 18 Nov 2007 09:15:58 PM