5 Replies Latest reply on Jul 7, 2018 1:30 PM by Farshad Rastgouy

    How do I break down a measure into a new measure of its constituent parts?

    Farshad Rastgouy

      I'm working with data regarding the average salary of people in the uk.


      There is one column for "Earnings" and there are other columns for other information, such as "Year", "Gender", "Geography" and "Working Pattern".


      What I want to do is create a field that determines the difference in salary between the genders.


      Under the column for gender it gives you the salary for men and women and so you can filter in tableau to see the salary for the different sexes separately. However, I don't know how to create a new measure that gives me the earnings for only males or only females.


      If I could break down the "Earnings" measure into the earnings for men and earnings for women, I could subtract them from each other to create a field that just gives me the gender salary gap.


      If anyone can help me on this, it would be greatly appreciated