8 Replies Latest reply on Aug 22, 2018 6:05 AM by Sankar achari

    How to create two new columns out of one column

    Sankar achari

      Hello Tableau...!


      I have table of two columns. Column Product and column sales.

      Now I created a calculated field :

      IF SALES > $1000 THEN "Target Achieved"

      ELSE "Not Achieved"



      After creating calculation field I dragged the same in text mark.


      Now a column will display Achieved and Not Achieved against each product.


      Now I would like to aggregate(count/sum) the Achieved and Not Achieved.


      How to do the above activity?


      I want to show Number of products Achieved and Not achieved in Dashboard.

      I want to show sum of sales products which are 'Achieved' and sum of sales products which are 'Not Achieved'.


      Thanks in advanced.