Aggregate Subset of Dimension

rtsander
rtsander
in 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:

Answers

  • Misbah
    Misbah

    @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

     

Categories