Issue trying to apply two different filters on one object

[Marvin Falentin]

Hey everyone,

not entirely sure if this belongs here or to "Framework Manager", but I think this end might be the right one.

I want to compare a value (totalcpu) in an Active Report in a list with the average (of the last 30 days) of that value avgtotalcpu). One requirement for the list is to only show the last 2 days so I have a filter in it saying "[Starttimestamp] >= _add_days(current_date; -30)".

My problem is how to set up the quary subject / data element / whatever "avgtotalcpu" so the filter mentioned above will not "overwrite" the internal filter of "[Starttimestamp] >= _add_days(current_date; -2)" from "avgtotalcpu", any ideas how to solve this problem in Cognos 11?

Kind regards,

Marvin