Hi,

I am not sure what I am asking for is possible with a saved search, but wanted to see if anyone knew how to do it.

We need a search that shows the items a customer orders as well as the average number of days between the purchase of said items. For instance our customers order the same items on a pretty regular basis. If the customer is ordering the item say every month we would like to be able to see this in a search. The search should look something like this.

Customer  |  Item   | Average Days Between Purchase | Days since last Purchase