I want to make a report with three columen (Quantity (New Order), Quantity (Regular Order) and Quantity (Total Order)). If a Customer didn't ordered a product within 365 days from the last order, the Quantity of the Order should be under New Order and else in the Regular Order. At the moment I have no clue how i should do that in Report Studio. Any advice?
This topic has been locked.
5 replies Latest Post - 2013-01-22T18:50:41Z by DanielWagemann
Pinned topic days between orders
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-22T18:50:41Z at 2013-01-22T18:50:41Z by DanielWagemann
Re: days between orders2013-01-22T15:26:40Z in response to SystemAdminSo DMR woud allow you to use the dimensional lag or previous member to get the previous order date value. Try implementing one of those functions.... If you are still having problems, please post an example against the Samples GO Sales(analysis) package and I will see if I can help you further.