Forum Discussion
Changes in item code
Thanks Greg. I've updated the initial post to include tables. Hope this helps!
I think that what you need to do is to make your product change table inclusive. By that I mean, you need to have it so that you would add records for:
Product 1 -> Product 1
Product 6 -> Product 6
If you had it that way, then you could use the Item ID column from this table in your first result table and the Item ID column from your fact table in your second result table. This would give you the intended effect of seeing it with or without changes. You could then create a button or two that would be tied to bookmarks to switch between the two views of the data.
Thanks. I think in your solution you meant Product 5 instead of Product 1?
Even if I made the table inclusive, it wouldn't solve the issue where product 8 changed to product 4 in 2017 and then to product 1 in 2018.
If I were to use the product changes table in this case, it would show me sales for product 1 and product 4 filtered for 2017 and 2018 dates. It may even put product 4 sales in product 1 and repeat product 4 sales again given it's a seperate line item. Is there another way I can adjust my tables to account for this issue of multiple product changes?