Saved search for Amount spent by customer in one year on sales orders

Answered

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

Saved search for Amount spent by customer in one year on sales orders

Saved search for Amount spent by customer in one year on sales orders

Rookie Asked on January 23, 2020 in Saved Searches.
Add Comment
1 Answer(s)
Best answer

In your criteria add Date (or date shipped).  For the date range there are several ways to write it but I would do “After”  and 12 months ago.

Beginner Answered on January 23, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors: Tipalti