2 Replies Latest reply on May 3, 2018 10:12 PM by Abhishek Singh

    How to write nested case if statement or any other calculation method

    Abhishek Singh

      Hi tableau Users,

       

      I am stuck at one place.
      I want to create a column in which it represents the name of the product if that product contributes more than 90% of sales for a firm of all the product sales.

      Below is the view in which i want (check the last column)

       

      CompanyProdSales% of salesNew column
      AMob6060%Mob
      Tablet820%Tablet
      Television3225%Television
      BMob9595%Mob
      Tab5100%MOb

       

      I am attaching my tableau twbx with this.

       

      Thank you in Advance

       

      -Abhishek Singh