I broke this into 2 pieces - you can do it in 1
First I limited the % calculation to the 2 ship modes with this
I then used that calculation is the one below to provide a summation in the grand total row
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.