Extract data from start and end validity

[sigtopo]

Hi,

I've got a table with product and starting/end date of marketing, like this :

Product	start of marketing	End of marketing
Produit A	01/01/2018	31/01/2018
Produit A	01/01/2019	31/01/2019
Produit A	01/01/2020	31/01/2020
Produit A	01/01/2021	31/01/2021
Produit A	01/01/2022	31/01/2022
Produit B	01/01/2018	31/01/2020
Produit C	01/01/2019	31/01/2023

I want to get this visualisation : 

	active product	discontinued product	new product
2018	2	0	2
2019	3	0	1
2020	3	0	0
2021	2	1	0
2022	2	0	0
2023	1	1	0

I used a table of dates in years

I used COSSSJOIN function to obtain a table with for each year the existence of the product or not. But I cannot compare and obtain the desired variations between years (discontinued products or new products)

[lbendlin · Accepted solution]

you can do the cross join in your measures automatically as long as you keep the tables disconnected.

see attached