Complex Scoring

Hi everyone, I was thinking on solving this but I got stuck to the last part.

So imagine you have this kind of table

The goal is to have something like this

Basically I want to put that into a Matrix Table.
let me explain the Logic.

1. First is we want to groupby Order Number and Order Line Number+
2. Column D = is a sum(qty) of the Last Time(from Date Table) the Order Line Number is booked.
3. Column F = is the sum(qty) of the first time(from the date table) the Order Line Number is shipped
4. Column G is the score, the logic there is both value from Column D and Column F are equal it will be 1 point, otherwise its 0,
   The tricky part is on the grand total. if you look at the one I circled, Order Number = AAA, you can see that the total is 6 for column D and 6 on column F, even Order Number AAA score is only 1, they will still get a score of 3(the reason its 3 its because of the number of unique order line number) on the total because they have the same number in the TOTAL level.
   
   Let me know if this makes sense.