Hi all. I have a bunch of child tasks that all have a work effort estimate assigned in man days. These all roll into parent tasks that do not have a priority. You can have different priority child tasks within a parent task.

I have created a new text field called 'Priority' and have assigned a number 1, 2 or 3 against each child task.

All I am looking to do is filter on that Priority field and see the total Work Effort of those child priority tasks combined.

I can't currently do this as a child task rolls up into parent task, and so Work Effort reflects the parent task (not assigned a priority) AND the child task (assigned a priority).

Thoughts please!