1 Reply Latest reply on Jan 30, 2014 9:39 PM by Prashant Sharma

    Calculated field for % of subtotal

    Jane Yang

      Hello Tableau gurus,

       

      I'm trying to create a calculated field that, for each row, gives the percent a value is of a subtotal. Attached is an example of the basic data structure. A real life example of this would be payroll time allocations: for a given individual who splits charging between multiple categories including Numerators 1 and 2, and with a total number of hours captured in Denominator, how can we calculate for each row the percent of the total hours (Calculated Field 1 and 2).

       

      I imagine this is some combination of TOTAL() and SUM() functions. Any help would be appreciated.

       

      Thank you!
      Jane