Post reply

Show counts by month from an as of date

  • March 19, 2014 at 9:18 pm

    #396450

    I need to create a report that shows counts of orders for 12 months starting with the date the report was run. For example. I have 5 stores and run the report today. The format should look like this. I am filtering the data by the order date starting with the date the report is run and going back 365 days. The header of the columns should reflect the Month and Year being totaled.

    Store Mar-2014 Feb-2014 Jan-2014 Dec-2013 Nov-2013 etc for 12 months

    store 1 total order total orders total orders total orders total orders

    store 2

    store 3

    store 4

    store 5

    I can get it to work if I use an expression to get the month and hardcode each column, but I want it to reflect the starting month.

    Thanks

  • March 20, 2014 at 10:28 am

    #1698775

    It sounds like you need a column group.

    Take a look at: http://msdn.microsoft.com/en-us/library/dd255263.aspx

    HTH,

    Rob

  • March 20, 2014 at 11:53 am

    #1698822

    That works perfectly. I don't know why I didn't think of that.

    Thanks!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply