I have a Pie Chart that is showing incorrect data but I do not know how to correct it. It is showing Orders that have been shipped either Late or On Time. The problem is I have 1 order where part of it was shipped on time and the other part was late, therefore it is appearing in both groups as you can see in the image. I just want it to appear once like the first table in the image but I cannot do this in a Pie Chart as I need to group it by ActualOnTime field, but when it does that it duplicates it.
What can I do to resolve this issue?