Calculate an Order Total in a query with multiple orders

[snipe]

Hey guys, here is a snippet of a query I am working on. I am trying to automate a very tedious excel spreadsheet that is used to track our online sales.
Name: Screen Shot 2015-08-26 at 3.14.41 PM.png  Views: 7  Size: 62.5 KB  ID: 21839" class="thumbnail" style="float:CONFIG" />

Here is a snippet of the excel sheet that I am trying to emulate:


How can I get a total for each individual order, like in the excel sheet?

[June7]

Build a report and use Sorting & Grouping features with aggregate calcs in report and group footers.