4 Replies Latest reply: Dec 7, 2016 2:33 AM by Siew Peng Lim RSS

    How to derive the computation to get the best selling product in my example?

    Siew Peng Lim

      Hi.

       

      I have 2 data tables that look something like the below:

      Sales table

      YearMonthDayProduct TypeModelSale
      2016Jan1RefridgeratorR1A10
      Washing MachineWM12
      TVTV25
      2RefrigeratorR2B5
      R1A3
      Washing MachineWM23
      TVTV210
      FanF34

       

      Countries where products are sold:

      CountryProduct TypeModelProduct Desc
      AustraliaWashing MachineWM1...
      WM3...
      TVTV1...
      TV2
      RefridgeratorR2A
      SingaporeWashing MachineWM1
      WM2
      TVTV3
      FanF3

       

      I have to produce a table visualisation that will display the product type, product model and the description that sells the most based on filters by year, month, day and/or country.

       

      May I know how this can be done? I tried to combine the above 2 tables by doing a join and performing a count at the load script and performing a count but I realized that if i do it, my count won't change if I perform a filter.

       

      Would appreciate it very much if someone can advice me how to go about computing for this visualization.

       

      Thank you and Regards,

      Siew Peng