6 Replies Latest reply on Jul 28, 2016 3:15 AM by Shaji Mathew

    Selecting last 3 dates from a list of dates dynamically

    Shaji Mathew

      Hi,

      I have a list of dates against sales as below.

       

      Date

      Sales

      27/07/2017

      1000

      26/07/2017

      2000

      25/07/2017

      5000

      15/07/2017

      1000

      14/7/2017

      10000

      13/07/2017

      8000

      12/7/2017

      2500

      11/7/2017

      7500

      8/7/2017

      9000

      7/7/2017

      12000

      6/7/2017

      750

      5/7/2017

      500

      4/7/2017

      6000

      1/7/2017

      15000

      30/06/2017

      12000

      29/06/2017

      8000

       

      I need to display the last 3 days details and corresponding sum and average.

      I used MAX to trace back the last 3 days but seems not working.

      Any idea how to resolve this.

      Thanks.