Aggregate Subset of Dimension




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.




  • Misbah


    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.