2 Replies Latest reply on May 10, 2018 7:13 AM by Zhouyi Zhang

    Help with Calculated Field and Subtotals

    Ray Zedov

      Hello,

       

      I am a relatively new user to Tableau. I need help with what is normally a simple calcuation in Excel.

       

      As you can see below, I am trying to calculate the attainment by using the following formula: [Total Gross]/[Dir Quota]

       

      The calculation is working correctly at the summary level, but not in the subtotal level. $213,499 / $363,840 = 58.7%, however the calculation is showing 177.5%, which is the sum of the calculations below.