2 Replies Latest reply on Feb 22, 2016 1:24 PM by Brad Gaston

    Sum an Aspect of a Dimension

    Brad Gaston

      I am trying to create a calculated field that returns just the overall Male 2015 headcount and another that returns just the overall Male 2016 Headcount and the same for Female.  The example below illustrates how the data is setup in the Data source.  Department and Region are listed only for illustrative purposes.   Any thoughts on how to accomplish this?    I am fairly new to Tableau so their maybe a simple way to accomplish this via a calculated field.  Their maybe another way to get the result other than a calculated field.  However, I don't want to get the result via reshaping the data or just applying the Gender as a column in the Visualization.