Forum Discussion

Arydperez's avatar
Arydperez
Frequent Visitor
5 years ago
Solved

Filter rows in a table with group condition

Hi,

I have the following Table

RowCustomer #Type Contact NameComments
11ACCTJoeIs ACCT
22ACCTTedIs ACCT
32PURCHMariaNot ACCT and ACCT Exist for this Customer in other row
43PURCHEdyNot ACCT but  ACCT Does NOT Exist for this Customer

 

There are only 2 option of Type Contact: ACCT or PURCH

I need to filter the rows with the following conditions:

1. If Customer Type Contact is only ACCT, the row needs to be included.

2. If for a Customer there are both type of Contacts, select only ACCT.

3. If Customer Type Contact is only PURCH, the row needs to be included.

 

In the example, Green Rows should be included and the Red Row should NOT be included in my data.

I was trying to get a calculated row or measure that give a binarial value include /not include but I couldn't find a right one.

 

Thank you vm for your help!

2 Replies

  • Arydperez's avatar
    Arydperez
    Frequent Visitor

    Thank you very much! Just switched "Y" and "N". Nice solution creating a calculated column.