I have data like the following
Property - which is nothing but a grouping of Brands
Ex. Fridge as a property will have brands like Samsung, LG etc,
TV as a property will have brands like Sony, Samsung etc.
Assuming sales are stored at the Brand Level and there is a table with Property, Brand mapping
Now i would like to show a chart with an expression as sum(sales), the dimension values should be Fridge, Samsung, LG, TV, Sony, Samsung etc.
Basically a synthetic dimension of Property and Brand.
Again, there could be 100's of brands and properties, so would need a fexible solution
Any pointers/help is appreciated.