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

    Count number of clients new, lost and existing


      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



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






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