Set analysis help

[chiru_thota]

Hi All,

We have a metric to show only closed Orders and we have implemented set analysis with filter.

Now the issue is with selection.When user selects some other status ,Orders Closed always showing data.

Example : In below screen user selected Status = Open.But report showing other status also as we have Orders Closed metric.

is there anyway to get output as shown in screen2 and still having filter on Status=Closed for Orders Closed metric;

I have attached QVW also.

Screen 1:

I

Screen 2:

[swuehl · Accepted solution]

Try with intersection operator *

sum({<Status*= {'Closed'}>}Orders)