I want to create a query that tracks a customer's order patterns on a monthly basis over the last 12 months. I have completed the query, however there are a couple of months (eg Nov-03) were no orders have been placed by any customer. I want to know how to display the month with 0 sales rather than it not appearing at all.
Thanks in advance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!