Filter selection

[m_riveravega]

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!

[Anonymous]

Can you put this data in an excel file, and give the required output in that file as well and share it here?