7 Replies Latest reply on Oct 18, 2018 2:27 AM by Mahfooj Khan

    Should show Sales Amount for Order Date - 90 days (i.e on the particular date)

    kamal kumar

      Hi All,

       

      I want to show sales for only (Order Date - 90 ) date.

       

      Example:

      My Order  Date selection is 12/30/2018.   Actual sales on 12/30/2018 is : $714

      For that Order date selection I need to know what is my sales Value on (Order  Date - 90).

      Actual sales on 10/1/2018 is : $2978

       

       

       

      Final  Result should show $2978 instead of $714

       

       

      Attached the workbook.

       

      Thanks in advance.