1 Reply Latest reply on Jan 13, 2019 11:52 PM by Mahfooj Khan

    Finding latest transaction date by a customer in a given week

    dare devil

      Hi all,

       

      New to this community.

      Would like to know the process to find the most recent transaction by a customer in any given time period.

      For example if we consider a time period of one week from Oct 21 2018 to Oct 27 2018 and a customer did three different transactions in the given week, I am trying to find the most recent transaction date by that customer in that week. I created a filter with range of dates and then created a calculated field using fixed customer name and max business date, but it is showing all the transactions by the customer in that week.

      Thanks in advance.