Unfortunately I cannot open the workbook (i only have 9.3).
But without looking at this issue, I think a level of detail calculation could work as well? In the below link, check out Example 2 specifically.
Hope that helps and hopefully someone else can help you as well Good luck!
Thanks for your feedback. I will see if this will answer my question…
Cedric B. Wood | Sr. Industrial Engineer
Saia LTL Freight | Atlanta Corporate Office
11465 Johns Creek Parkway Ste 400 | Johns Creek, GA 30097
image001.png 45.5 KB