Sum of previous weeks

[the_xxx]

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

[MFGF]

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.