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
Hi Jane,
When you right click on your measure then in Quick calculation there is an option of % of Total. After this you have to compute this using your pane. Check this thread: - Percentage Options
Hope this may help!
Warm Regards,