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.



      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



      Can anyone help me with this please ??


      I have attached my workbook also.