4 Replies Latest reply on Oct 4, 2017 6:08 PM by Brigitte C

    Sum results from multiple dimensions

    Brigitte C

      Hello,

       

      New to Tableau and I have tried to create calculations to solve this but I think I may have overcomplicated things.  Is there a simple way to do this?

       

      I have three fields that have the same response values (Yes, No, NA or Null).  I want to count all of the response values across the three dimensions for an overall total value.  For example, if I have 17 "yes" responses in the "Check 1" Dimension, 3 in the "Check 2" and 1 in the "Check 3" I want a "Total Check" field to show as Yes = 21.

       

        I have created a basic example workbook here with the three fields.

       

      Thanks for any help!

       

      Brigitte