filtering out a specific source for a specific month?

building reports webintelligence
1

Hi,
I am bringing in “Source” X, Y and Z for Jan thru June 2011. But I need to filter out “Source” Y JUST in Months Feb and March 2011, but keep “Source” Y data in Jan, April, May and June.

Currently I am manually making change to .xls output, but there has to be a way in Webi XI v3, right??

I tried a Minus Union of query1 with query2 where “Source” = Y and Date between Feb 1 and March 31. Didn’t work.

Also tried a subquery where query 2 “Source” not equal to Y and date between Feb 1 and March 31. Didn’t work.

bohonkus :us: (BOB member since 2008-04-10)

2

Flag=If([Source] = “Y” AND ([Months] = “Feb” OR [Months] = “Mar”);1;0)

Then apply a filter on Flag <> 1

jprasanthram :switzerland: (BOB member since 2010-12-10)