When looking at why volume changes, we want to look at price, promotion, velocity and distribution changes. I think most measures other than volume and price are weighted by ACV%, so not sure how that would work with Amazon but at the very least t...
Create an Item_ASIN dimension just like Item_UPC, so that when converting the data table to a pivot table, you can see the Item and number identifier all on the same row.
Amazon is a choice when filtering Geos by the word "total"
Not that this isn't useful, but it doesn't follow the filter rules. I tried it with other words in the filter, but it only appears to happen with "total" and "amazon"
1
Future Consideration