2 Replies Latest reply on Feb 10, 2014 5:47 AM by David Kirk

    Recalculate calculation based on groupings selected

    David Kirk

      Dear all,

       

      I apologise if this is a very simple question but I am new to Tableau and have hit a stumbling block.

       

      I have a data set which contains 2 dimensions (category and department) and two measures (applications and applications processed)

       

      I have a calcuated field which is called percentage of applications processed and is basically the applications processed divided by the applications.

       

      This all works well if I break the data down by both dimensions.  What I want to be able to do though is break it down by one or the other.  When I do this it aggregates the calculation so instead of 89% I get 345%.

       

      Is there a way of getting the caclcuation to recalculate based on the data it is seeing rather than the raw data?

       

      The data:

      CatA     DeptA     10     5     50%

      CatA     DeptB     20     5     25%

       

      What I want:

      CatA     30     10     33%

       

      What I get:

      CatA     30     10     75%

       

      I hope that makes sense.

       

      Thanks