Hi. I´m trying to use percentoftotal to calculate between two different fields. I´m attaching image as example the field LPU Run between the total of field Runs. For this example for the line of Carrier Delay highlighted in yellow divide 1 / 202 as total runs. I want to add this in a new field named Controllable %.
Hello @eedmundo , welcome to the Quicksight community!
Have you tried the following:
sumIf({LPU Run}, {Pick up} = 'Carrier Delay')
/
sum({Run})
Let me know if this works!
Hi, I tried the test, but the result was (1/28) instead (1/202). It only divides in same line, instead divided per the total.
Hi. I solved the issue combining this fix but generating a new calculated field for each category and removing the field Pick up. Thanks for the support 
1 Like