0 Replies Latest reply on Oct 25, 2012 3:10 AM by Christopher Henderson

    How to identify drop offs in sales

    Christopher Henderson

      Hi All,


      I have a database containing the sales of our products by account and by product name by month. What I have been asked is whether it is possible to label or categorise accounts that have not bought anything (null sales) within a defined amount of time.


      The measurement needed across all accounts and all individual products using the following rules:


      1. If the account has not bought the product within the last 2 months then label 'amber'

      2. If the account has not bought in the last 3 months or longer then label 'red'


      What is the best approach for something like this?