Hi all,
I have an issue where due to the way two different data sources are structured I end up with something as the example below:
SKU Number | Sales QTY | Date | Promotion Text | Promotion Qty |
123456 | 20 | Jan 2019 | Promo 1 January | 2 |
123456 | 20 | Jan 2019 | Promo 2 for 1 Jan | 8 |
123456 | 20 | Jan 2019 | Promo 2 January | 1 |
123456 | 20 | Jan 2019 | Promo 3 for 4 | 0 |
123456 | 25 | Feb 2019 | Promo 2 for 1 Feb | 1 |
123456 | 25 | Feb 2019 | Promo 2 Feb | 6 |
123456 | 25 | Feb 2019 | Promo 2 for 4 | 2 |
My issue is now, that one SKU can be in one month on multiple Promotions (Promotion Text needs to be distinguishable, and in separate rows as analysis afterwards will be "How much products do we sell through Promo vs. Non-Promo") and the Sales QTY for SKU #123456 is currently 4 x 20, although it actually is only sold in total 20 times in January. As I use this data to build Tableau Dashboards I need all Sales QTY fields except for one to be empty, so when looking at Sales QTY January vs. Promotion QTY Total it would be 20 vs. 11, but when looking at Sales QTY vs. 'Promo 2 for 1 Jan' would be 20 vs. 8.
I hope this makes any sense to someone of you...
Thanks a million!!
Solved! Go to Solution.
That's perfect, it definitely did the job! Thanks a lot @deviseetharaman !