Year over Year sales variance when product sold in both years

1

I am analyzing margins for a list of products and there are obviously products that were sold last year that did not sell this year and vice versa. Has anyone ever built a report that only returns products that were sold in both years? I think this would give us better insight into pricing decisions we’re making (or should be making). Thank you

2

You can add that with advanced search for any number of time periods.

image
image1672×286 32.7 KB

In the example from our database it dropped from 487 products examined to 281.

3

That’s fantastic. Thank you!