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.
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.