2 Replies Latest reply: Jul 26, 2018 7:32 AM by Sunny Talwar RSS

    How to show all customers

    Wanyun Yang

      My Customer table is like:

      111.PNG

      Sales Category table is like:

      222.PNG

      I'm trying to create a pivot table and a Category filter. I want to implement:

      1. By default, it's showing YES if a customer sales either apple or banana, NO if a customer sales neither.

      333.PNG

      2. If select APPLE, show YES for customers who sales apple, NO for customers don't.

      444.PNG

       

      I'm creating the model by Sales Category left join Customer. My function is:

      IF(COUNT(Category)>0,'YES','NO')


      It works well without filters. But if I selected only Apple, it would only show C2 &C3 with 'YES'.

       

      How should I modify my model or function?

       

      Thanks in advance!!!