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"

      END

       

      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.