Figure 2: Desired Results—Base Order Lines, with Aggregates

orderid

line

pos

productid

qty

qtyper

val

valper

43659

1

first

776

1

3.85

2024.994000

9.85

43659

2

mid

777

3

11.54

6074.982000

29.54

43659

3

mid

778

1

3.85

2024.994000

9.85

43659

4

mid

771

1

3.85

2039.994000

9.92

43659

5

mid

772

1

3.85

2039.994000

9.92

43659

6

mid

773

2

7.69

4079.988000

19.84

43659

7

mid

774

1

3.85

2039.994000

9.92

43659

8

mid

714

3

11.54

86.521200

0.42

43659

9

mid

716

1

3.85

28.840400

0.14

43659

10

mid

709

6

23.08

34.200000

0.17

43659

11

mid

712

2

7.69

10.373000

0.05

43659

12

last

711

4

15.38

80.746000

0.39

43660

13

first

762

1

50.00

419.458900

32.41

43660

14

last

758

1

50.00

874.794000

67.59