Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Aug 10, 2017, 6:19 AM

Filter customer by department

Hi All,

 

Need help in calculation-

 

In given below table i want to show customer who purchased in furniture and office supplies but not in technology.

 

Filter customer by department

Thanks

Aman

4 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Aug 10, 2017, 8:23 AM

    Hi Aman,

     

    Try this:

     

    [Calcul 1] :

    { FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )}

     

    [Calcul 2]:

    IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END

     

    You can change 'OK' and 'NOT' for TRUE and FALSE depending on your requirement.

     

    Hi Aman, Try this: [Calcul 1] :{ FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )} [Calcul 2]:IF { FIXED [Customer Name] : SUM(

     

    Regards,

    Vincent

Write an answer...
0/9000