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

    Show excluded values in pivot table

    Ruytter Mendonça

      Hi.

       

      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?