5 Replies Latest reply: Jun 2, 2016 3:10 AM by Pravesh Dukhi RSS

    Set Analysis issue. Need to create a report that pulls for the current month(June 2016), a list of customers whose last purchase was May 31, 2015 or earlier.

    Neena Bhattarai

      So basically the report needs to go back 12 months to 24 months of the last purchases made by the customer. So the full span from last purchase is June 1, 2013 to May 31, 2015. So, the report would look at all customers in our database and if their last purchase was 12-36 months ago, pulled into a report with no purchases in the current year. I am having difficulty understanding Set Analysis. I have looked at many articles but I can't seem to get my expressions to work. Any thoughts on why my expressions below aren't working?

       

      =sum({$<[Fiscal Month]={"<$(=Month(Today(),-23))"}>}[Sales Amount])

      =sum({$<[Fiscal Month]={"<$(=Month(Today(),-11))"}>}[Sales Amount])