This content has been marked as final. Show 2 replies
I am looking to run a report that will provide me a list of customer's last order date was prior to a filtered date and also return the previous twelve months sales for each customer paste on the same last order date.
For example, I the list of customers I would like to return is based on the following: [Last Order Date] was prior to 6/30/2012 and for each customer, provide their trailing twelve month sales based on each individual customer's last order date. Sample data:
|Customer Number||Last Order Date||Sales Order Date||Item||Sales||Order #|
|Customer Number||Last Order Date||Trailing Twelve Month Sales|
|The 2/1/10 order would be excluded|
|Phil had sales after 6/30/12 cutoff|
Would I be able to use the datediff function with the field [Last Order Date] and the 6/30/12 date?
Thank you for any assistance you could provide.