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.

       

      Thanks