0 Replies Latest reply on Jul 13, 2018 3:05 PM by Vidya Sagar Malla

    Grouping the Dimensions using the measures

    Vidya Sagar Malla

      Hi,

       

      I have a very simple requirement. But I am struggling to get along with it. Please help me in sharing the idea or logic.

       

      Here is the brief information with the sample Phones data.

       


        And here is what I want to achieve in Tableau.

      • Rank has to be generated based upon the Product Subcategory and Product Name for each Product Category
      • Rank Parameters: Now I have two Rank parameters
        1. TopN: Contains drop-down values of 1,2,3,4,5,6
        2. NextN: Contains drop-down values of 1,2,3,4,5,6
      • TopCategroy: Now what I want to achieve is when I select 2 from TopN parameter Topcategorycalculated column should give me the string output  as Top 2 Products with SUM of the price for the first 2 products and when I select 4 from the NextN parameter Topcategorycalculated column should give me the string output as Next 2 to 4 Products with SUM of the Price for 3rd and 4th products.
      • Ultimately I want to show them in a PIE chat just like the below image.

       

                                                                                                                                                      

      Product   CategoryProduct   SubcategoryProduct NamePrice
      SmartPhonesAppleApple S10$         100
      SmartPhonesSamsungSamsung s7 Edge$         200
      SmartPhonesNokiaNokia 5120$         300
      SmartPhonesNokiaNokia 9$         400
      SmartPhonesSonySony Xperia$         500
      SmartPhonesMotorollaMoto Rock$         600
      LaptopsAcerAcer Aspire R$         700
      LaptopsAcerAcer Alpha$         800
      LaptopsHPHP Specter$         900
      LaptopsHPHP ENVY$      1,000
      LaptopsDellDell Inspiron$      1,100
      LaptopsLenovoLenovo Flex$      1,200

      I worked with many BI tools like Tibco Spotfire, Qlik, Microsoft Power BI. I have achieved the same result in no time. Since I am into this tool form last 2 days, unfortunately, I could not crack it.

       

      Your help will be much appreciated.