7 Replies Latest reply: Jun 17, 2014 11:23 AM by Ruytter Mendonça RSS

    Show excluded values in pivot table

    Ruytter Mendonça



      I have a straight table with the customers names and the sales value.

      I want to make another straight table but only with the customers that didnt have a sales value.


      What I have:


      Customer IDCustomer Name
      1Customer A
      2Customer B
      3Customer C
      4Customer D


      Customer NameSales
      Customer A10000
      Customer D50000


      What I want:

      Customer NameLast Sale
      Customer B50 days ago
      Customer D8 days ago



      The days ago I can calculate, but, i'm not being able to list who didnt have bought.

      Can you guys help me?