Forum Discussion

DGFranco77's avatar
DGFranco77
Frequent Visitor
2 years ago

Conditional on matrix result sold between dates

Dear friends, I have a table where I enter the quantity sold per product and the month (calendar). But I need to distinguish in the quantity result, within the product registration period. For example, product "ABC0516" has a registration date of 05/15/2023. In the period I need it to actually show Jan/2023 to Apr/2023 "blank" because it wasn't actually sold because it didn't exist. And between May/2023 and Dec/2023 it shows 0. How can this be done?

 











In the sales table I have issue_date and in the dimension I have product_registration_date, both related to the calendar dimension.

Please help me.
Thanks

Need Help

2 Replies

    • DGFranco77's avatar
      DGFranco77
      Frequent Visitor
      2 years ago

      Hi Ritaf1983 

      Sorry for the lack of clarity, but what I need would be to absolutely analyze all products regardless of whether they have sold or not, I know I can enable items without data. But I would like to condition them by month, as I show in the example below how I would like to see the result. Let's go, product M0537 was registered in the month of October, so the previous months of sales even though they are not in my sales table I would like to show blank because it did not exist and from October show as 0 because it came into existence, but, did not sell, I would like to know how to do this, even without the sales data in fact. The same happens for product M0539, but with some months with sales.

       

       

      Remember that I have a "registration_date" field for the product in my product table and "sales_date" in the sales table, which is what goes in the matrix. Maybe I need to work with these dates together. Both tables are already related by the product_code.

       

      Please let me know if this is clearer.

       

      Thanks