I have defined a saved search to retrieve total am...
# general
a
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
You can use date as a criteria maybe or add date field on the result tab.
👍 1
a
You mean to set date filter ? Can it be dynamic date filter i mean .. It takes current date and then gives result
E.g a saved search when opened takes the date of current day and gives results for last one year starting from curent date
b
use a relative filter
a
Thanks .. It worked .. @battk
👍 1