5 Replies Latest reply on Mar 23, 2017 12:37 PM by Deepak Rai

    Distinguish between identical employee IDs

    Ulrich Blode

      Hello, I am new to Tableau and I did not found the same topic in the forum or maybe I have searched the wrong terms. I have two employees with the same ID 001, but they are working in different cities and stores. The source is an excel file. When I have only the Employee ID in the row, then (of course) the sales of the two different employees with identical ID are added together.

      Is there any function to distinguish between the two employees without putting the store into the row? I only want to see the sales sorted by employee ID without the store classification.