0 Replies Latest reply: Jun 30, 2013 10:52 AM by Sudhakar Balakrishnan RSS

    Synthetic Dimension

    Sudhakar Balakrishnan

      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.