Have a look at the attached file. Is that what you wanted?
I've included 2 calculations for Shipment Delta and Shipment %, the first assumes your actual data (if your attached file is just a sample) includes the 'Shipment Delta' column. The second calculation only uses the first 2 columns of your data.
Let me know if you need any more help!
EDIT: I somehow attached your data instead of the qvw... my bad, fixed now
Actually Col D and Col E (in the last attached file) are calculated fields. We have now deleted the the columns in source file (new file uploaded now). Can you please help with the expression to derive the required output
I couldnt find out the data which you attached ..for summing up the rows use' rangesum' function and to find the Shipment Delta 'Sum(total A)-Sum( total B) Shipment % - (Sum(total A)-Sum( total B))/sum( Total A)