7 Replies Latest reply on May 21, 2018 5:44 AM by Ruben Arias

    Percentage of Total

    Ruben Arias

      Hello Tableau'ers.  I have a sheet with a calculated field which takes the $ diff and divides it by the total paid dollars.  This gives me the % diff, etc.

       

      Here is the calc field for $ diff :

       

      [Calc : Total Billed $]-SUM([Calc : Total Paid])

       

      Now, the last column called % diff is the following calc:

       

      [Calc : Total Billed $] / SUM([Calc : Total Paid]) -1

       

      My issue is, in the totals/sub totals % cell, it is calculating either SUM, AVERAGE, AUTO, MIN, MAX, etc...but the % is not correct for the totals/sub totals.  It is correct across the above rows.

       

      So if you look at the screenshot, right now I have it set to AVERAGE for the % totals.  It says %34.34, but really I want it to read the actual % which is %29.62 ($175.50/$592.50=.29620253)

       

      How do I accomplish this simple task. 

       

      Thanks, Ruben