5 Replies Latest reply on Feb 12, 2016 7:33 AM by Jaspreet Narang

    Calculated Contact Type Field

    Jaspreet Narang

      Hey guys,

       

      I have a data source that contains fields called Contact Type and Assignment Group.

       

      I want to have a calculated field where if the Assignment group is "Techbar" then it becomes the contact type in the original data source and replaces the old value. Below is a screenshot of a small subset of my data source.
      2.0.PNG

       

       

      After having the calculated field set up I want to display all the 4 contact types on an unstacked bar with their values.

       

      Below is what my unstakced bar looks like right now
      1.0.PNG

       

       

      Can anyone help me with this please ??

       

      I have attached my workbook also.

       

      Thanks,

       

      Jesse