1 Reply Latest reply on Jan 7, 2019 2:06 PM by Patrick Van Der Hyde

    How to get sum of two values of same dimension which has common measure.

    Sandeep Nair

      Hello Tableau Community,


      I m trying to get sum of values from two different column, but row wise.

      Eg in the attached screen there are 2 columns naming "False" & "True" under the heading rejected, For calculating total row wise I have used the formula as below.

      {FIXED [feature_detected],[iso_code],[modified_date]:SUM([count])}, With this I m getting total correctly at times under "True" heading & sometimes under "False" heading.


      Eg In the attached screenshot For Feature_detected as PedestrianCrossing value of False is 2998 & Value of True is 69, Therefore the total should be 3067 which is correctly reflecting under "False" heading but not for "True" heading.

      For Feature_detected as WindingRoadStartingLeft , value for "False" is 17 & for "True" is 15, Correct total of 32 is reflected under "True" only & "False" has incorrect total as 28.


      For Feature_Detected like NoUTurn, SharpCurveLeft etc Total for both False & True is correct.


      I m unable to understand if the formula I used above is resulting into such an output or something else.


      Would be grateful if someone having solution to this can assist.


      Looking forward to a resolution.

      Thanks in Advance.