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.