Hi,
I'm working with a database that includes products, sales, campaigns, etc. There are 18 campaigns in a year and they follow this structure: (YYYYXX), for instance, campaign 201602 or 201814. The two main tables with which I'd be working are:
PRODUCTOS: has a unique code for each product, description, category, brand....and the campaign each product was launched.
PERIODO: a table with each of the campaigns.
VENTAS: register of each of the sales made (which product, in which campaign, how many units, amount made, etc)
I would like to create a view based on the sales of "new" products. To recognise the new products I'm taking into account the campaign when it was launched. However, I would like to use a campaign filter where, if I choose a certain campaign, I would get the added sales of a product if said product has been launched during the previous year (18 campaigns). Eg. If I select campaign 201804, the chart should show me the sales of the products launched from the campaign 201704 on to the campaign filtered.
I wanted to know which measures I can apply to get the filtered sales.
Any suggestions are welcome,
Thank you!
