Hi, please help! I've created this TRANSACTION saved search to pull up the most recent invoices for each Customer. But we ONLY want to see customers that have not ordered in a while (base on their last invoice). Where do I add this formula? What is the exact formula?
My screenshots are below and it gives me the past rolling year's of invoices but this is not the date I want to see. I need the formula so it will do 2 things:
- Only show data from ONE invoice: the most recent invoice info (I don't want to see multiple invoices in the past year)
- Only show the last data from customers that don't have invoices in the last 4 months or more (based on their last invoice date/last sale).