Using Sum(TOTAL fieldname) only works when I select a value from another field

[mikegrattan]

I am attempting to get a percentage of total for each record in a Work Order.  My current expression is:

Sum(EU_RecQty) / Sum(Total EU_RecQty)

This gives me the percentage of the total received, but only when I am filtering on a specific Work Order.  I then multiply this percentage by Acres to get a breakdown of acres for each record in the Work Order.  Here's a sample of the result when I filter on a specific Work Order:

When I remove the Work Order filter and only filter on some other dimensions such as Season and Location, the numbers change.

I realize the scope has changed and I probably need to add a filter to my expression using Set Analysis; however, I am having a problem figuring out the right solution.  Do I use Aggr, or just add filters to my existing expression? (I've tried both but I'm not getting good results).

Now, the question is how do I adjust the expression so it will work when I am not filtering on a specific Work Order? 

Thank you for any assistance!

[Digvijay_Singh · Accepted solution]

Check if this gives the right value without using filter

Sum(EU_RecQty) / Sum(Total<WO> EU_RecQty)

[mikegrattan]

This works nicely...thank you.