3 Replies Latest reply on May 31, 2016 10:25 AM by anthony.pierzchalski

    New Sales

    anthony.pierzchalski

      I've attached the Superstore workbook and looking for assistance on the "New Sales" tab.  Lets pretend it's 2012 and I'm looking for a filter that will show me the new sales in the year.  For example Adam Bellavance would be the 1st Customer to show up on the list.  I've tried MIN Order date and checked various posts, but I'm still not getting what I need.  I'm probably just missing it.  Any help would be appreciated.

       

      Thanks

       

      Well I thought this was answered, but now I need to add customers that had sales of less than $20,000 in 2011 along with new sales in 2012.

       

      Thanks