I have defined a saved search to retrieve total amount spent by each customer (grouped by email) on sales orders. What should i do if i want the same result but for last one year starting from current month ? .. In other words .. Amount spent by customer in one year on sales order
c
Christian W.
01/23/2020, 10:13 AM
You can use date as a criteria maybe or add date field on the result tab.
👍 1
a
Ahmed
01/23/2020, 10:16 AM
You mean to set date filter ? Can it be dynamic date filter i mean .. It takes current date and then gives result
Ahmed
01/23/2020, 10:18 AM
E.g a saved search when opened takes the date of current day and gives results for last one year starting from curent date