4 Replies Latest reply on Feb 1, 2017 7:02 AM by loic lotito

    How to display on a map only customers who have not purchased a product category type

    loic lotito

      Hello everyone,

       

      I have a data table gathering a list of customer invoice.

       

      My goal is to keep only customers who have not bought a product cat in this list.

      I have to allow the end user to select the elements to be filtered in the filter

       

      When I do an exclusion on the filter, only the product disappears. And my objectif is to display only customers who have not purchased a type of product category.

       

      To illustrate my problematic here is a small example : I wish to display only customers who did not purchase the cat A product.

      Once the filter applied, customers having Cat A product still appears (highlighted in yellow), and only the Product cat A disapear.

       

      I tried different custom calculations field without success : LOD, EXCLUDE...

       

      All advice is good to take

       

      Thank you Tableau community

       

       

      display.PNG

      display 2.PNG