2 Replies Latest reply on Aug 12, 2013 5:09 PM by cholavendan.ilangovan

    How to split the values which are in the same field (Flag column) and divide

    cholavendan.ilangovan

      Scenario: I have two choices (like: Manager and Staff) for each department under one field (Manager/Staff Flag), I am using the EMP-ID measure to count the number of Manager and Staff. I am struck when I need to divide Number of Staff / Number of Manager since both the types are in the same dimension (Manger/Staff). Do I need to split the data in the source - excel or can it be done in Tableau. If I havn't described my question properly, plz take a look at the attached file. Thanks for your time.