I'm currently looking for a way to create a new column (by using sql) that sends me back the total amount of the last 12 months, for a specific product and a specific month.
My file looks like the one below :
Date | Name of the product | Sales |
and I would like to create a new column wich is an amount of the last 12 months sales.
Date | Name of the product | Sales | Sales_last 12 months |
Does anyone have any ideas to do this ?
Thank you in advance for your help !
Please sign in to leave a comment.