Aggregate Subset of Dimension

Options
rtsander
rtsander Member, ALL USERS, Community Member Posts: 1 New Contributor
in Planning & Modeling

Hello,

 

I'm trying to figure out the best way to aggregate a line item with two dimensions (SKU and Sales Channel) by Channel. 

 

For example, I would like all sales for a specific SKU for only website or Amazon channels. 

 

The issue I keep running into is my aggregation line item dimension should only be SKU to save on size, but I'm then finding it difficult to filter on Sales Channel.

 

Thanks!

Tagged:

Categories