9 Replies Latest reply on Mar 21, 2013 6:19 AM by Alex Kerin

    HELP!! Salary figures are summing oddly!

    Kate Abercrombie

      Hi -

       

      I have data for people and salaries. Due to the way that the data needs to be formatted for Tableau, I have multiple rows of the same salary data for the same person. For example, I have ten rows for John Doe with his salary of $50,000 for each row. When I want to look at the total salary for multiple people, it adds up all of John Doe's ten rows. I do not want it to do this - I want it to count John Doe's salary once. How do I do this?

       

      Thank you!

       

      Kate