0 Replies Latest reply on Feb 27, 2013 10:37 AM by Adel Nero

    How to calculate total sales for a customers first 365 days after their first purchase

    Adel Nero

      I have a sales table that contains all of my company's orders going back to 2009. I need to identify customers who bought for the first time between 2/26/11 and 2/26/12 and calculate the $ amount they spent with us within the first 365 days of their original purchase.

       

      Can someone please help point me in the right direction as to what functions I should be using to put this into a Viz.