This is more of an idea question rather than a specific formula question.
What I'm doing is tracking sales per product through a pivot. But now I'm running promotions on products and attempting to see how these affect sales on the dates the promotions were running. Having writer's block here on the best way to show this.
I have hundreds of product SKU's which fit into different categories of promotions that will be running on different weeks. I could simply just highlight those days sales for every product. Or add an extra row and mark products being promoted that week.
Just stuck on how to show this in a summary chart, to see differences from promotion/no promotion especially since the dates can be "sporadic" across hundreds of products. Maybe adding a row to the sales data--cross referencing that from the promotion name AND the dates. Now I would have the products marked as being promoted that day. Then pivoting that data out separately / referencing it against the regular non-promotion sales.
Any ideas or suggestions on how to show this data? Has anyone done anything similar? Sorry if this doesn't make sense
Bookmarks