9 Replies Latest reply on Jul 2, 2018 8:05 AM by Simon Runc

    Count number of clients new, lost and existing

    carlo.fuggetta

      Hi all,

       

      I have a simple table with customers in the rows and two years in the columns summarizing sales by customer. (see attached example) I have been able to add a calculated fields which is colouring the lost, new and existing clients:

       

      IF ZN(LOOKUP(SUM([Amount$]),-1)) = 0 and LAST() = 0

      THEN

      'New'

      ELSEIF ZN(LOOKUP(SUM([Amount$]),1)) = 0 and LAST() = 1 THEN

      'Lost'

      ELSE

      'Existing'

      END

       

      Now I want a separate sheet counting the number of new, lost and existing customers across the same periods. How can I do that?