Hopefully someone can help us out here.
We have the following data pulled from a Sybase Stored Proc: (example)
Product | Order Status | SomeVar
A | D | 5
A | D | 10
A | D | 6
A | E | 7
A | E | 9
B | D | 1
B | D | 5
B | D | 4
B | F | 3
B | F | 88
C | D | 25
C | D | 3
C | D | 2
What we need, is to be able to group
the variables based on the product and order status and subtotal the SomeVar for each group.
IE:
Product | Order Status | SomeVar
A | D | 5
A | D | 10
A | D | 6
Subtotal AD = 21
A | E | 7
A | E | 9
Subtotal AE = 16
B | D | 1
B | D | 5
B | D | 4
Subtotal BD = 10
B | F | 3
B | F | 88
Subtotal BF = 91
C | D | 25
C | D | 3
C | D | 2
Subtotal CD = 30
Thanks
