I have an Order table where every time an order is placed it creates a timestamp for each order.
Order Created Date
Order1 1/31/2017 11:13:48 AM
Order2 3/31/2017 11:13:48 AM
Order3 4/31/2017 11:13:48 AM
Order4 5/31/2017 11:13:48 AM
Order5 3/31/2017 11:13:48 AM
Now I want to create a summary report where it shows:
Sales Person | Company | Jan | Feb | March | April | May | ......
X Person X company 1 0 2 1 1 ......
Is there some calculation I can use based on Created Date to count the order that have been placed in that particular month? In other words, I am thinking to create 12 new fields (Jan ... Dec) and using some calculation that will count the orders placed in it's particular month.
I'd appreciate any suggestions!