cosssjoin
1 Topic
Extract data from start and end validity
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)Solved476Views0likes1Comment