Saved Search of Order Items

Hi,

I'm trying to recreate the Order Items page because we need to change some formula.

I'm using an Item Search that will show us the details but I need other columns to be group and other to be summed based on internal ID of Item. Here's the search:

-The Demand Column should be totaled based on the internal ID

-Order quantity should be (total of demand + preferred) - (on hand + on order)

-Other columns should be grouped

Here are the screenshots of the search:

Results:

Criteria:

Thank You!