Rolling Rows Up To A Single Row with a Total

[pnn44794]

Hello:

I need to be able to roll up Orders, a single order can have multiple rows, into one row per order with a total sum amount in a straight table.  Net Assets should be summed or it might be best to count ORDERS IN (I'm not sure).  In other words, if Order 1 has 10 rows with a total sum of 15, it needs to be consolidated down to one row with a total of 15 for Outstanding Units.  I've attached a sample output format.  I should wind up with ~40 - 70 rows of data.

•  

As always, thanks in advance for any and all replies.

[pnn44794]

Actually, the yellow highlight is not working as expected.

[pnn44794]

Hello Tamil:

Sorry about this, but please disregard again the yellow highlighting problem I was having.  I have resolved it.

[pnn44794]

Tami;, you were absolutely wonderful to work with.  I appreciate your time and effort.  Thank you!