12 Replies Latest reply on Nov 15, 2018 12:05 PM by Deepak Rai

    Sum of sales for customers' first orders

    Alex Luke

      Hi, first post here. I'm trying to figure out how to calculate the sum of sales of the first orders of all customers. I've searched all over the internet and couldn't find a solution. I did find a method of identifying first orders based on something akin to IF [Order Date] = MIN([Order Date]), but that will include multiple orders if a customer makes two orders on the day she makes her first order. Any ideas?