5 Replies Latest reply on Aug 14, 2019 1:34 PM by Soumitra Godbole

    Calculated field based on dimension value

    Christian Song

      Hello all,

       

      I work with Tableau version 2018.3.

       

      I have a sample data attached look like this :

       

       

      I'm trying to do a COUNTD(Employee ID) based on the Year value, and then create a calculated field to as COUNTD(Employee ID) of 2019 -  COUNTD(Employee ID) of 2018.

       

      I have seen a few posts on this subject with sum(), but it doesn't seem to work in my case.

       

      Could anyone help on the exact script for the calculated field? 

       

      Thanks so much for the help.

       

      Best,