Incorrect data when making selections

[#1]

We analyse failed shipments to customers by reason codes. When we make a selection on code WHMP this will give us details of what shipmenst were involved.

We then have a  chart which includes the expression  'Count (Distinct If (FOCReason='WHMP', [Order Number], null()))'.  However the details also appear in another chart which includes the expression  'Count If (FOCreason='WHUP',[Order Number], null()))'.How do we stop this happening?

[rahulgupta]

Hey Hi,

You can use Set Analysis and ByPass the Filter,

For that you may use the following Code:

Count ({<FOReason=,FOCreason={'WHUP'}>}[Order Number])

Hope this helps...

Regards