12 month period - using sql

Comments

2 comments

  • Avatar
    Adam Bender (Edited )

    I think you can try something like I have shown below.

    I believe you're trying to get total sales over all time and sales in the last 12 months, right?

    If not and you're just trying to return the entire table, you can skip the grouping step and the first sum, otherwise this will give you what you need.

     

    ===============================================================

     

    0
    Comment actions Permalink
  • Avatar
    Mike Flanagan

    I'd be interested in knowing this as well

    0
    Comment actions Permalink

Please sign in to leave a comment.