Aggregate Subset of Dimension

rtsander
New Contributor

Aggregate Subset of Dimension

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!

1 REPLY 1
Misbah
Moderator

Re: Aggregate Subset of Dimension

@rtsander  

You can’t filter it until you have that as a dimension or it is an attribute of Sku (which seems unlikley)

You can extract the data into their own line items but you need as a many line items as channels - its as good as saying having channel subset as a dimension.Hence equal space consumtpion.

Misbah