4 Replies Latest reply on Jul 2, 2018 1:32 AM by Saharat Sakulsaowapakkul

    Creating Top N Sales Set of Sub-Category

    Saharat Sakulsaowapakkul

      Hi Everyone

       

      First of all let me show you a screenshot of visualization that I want to create using Tableau.

      Remark: Below is plain Excel and calculation manually.

       

      I want to shows "Top 3 brands" within each category which have the highest sales. To do this, there are so many options such as using Index between Category and Brand or creating RANK calculation (Pane down).

       

      However, the hard thing is I want to Group or to create Set for these Top 3 brand and SUM their Sales comparing with the rest brands.

       

      My latest try is below screenshot.