AnsweredAssumed Answered

Count orders by month

Question asked by robertkurti on Jun 7, 2018
Latest reply on Jun 7, 2018 by philmodjunk

I have an Order table where every time an order is placed it creates a timestamp for each order.

e.i.

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!

Outcomes