Use pivot TABLE

Refer the below link for help and once you get into the 'Dragging and
Dropping Data' drag and drop the first 3 field to the 'Row Field'
Drag amount field to 'Data Item' field.

http://www.microsoft.com/dynamics/us...s_collins.mspx


If this post helps click Yes
---------------
Jacob Skaria


"DanaK" wrote:

Why can't I figure this out!?!? It seems so simple....
I have three columns listing GL#, ST# & RL. The last column contains the
value to be allocated to that string. How can I subtotal by the first three
columns at the same time?
GL ST RL Amount
602600 05 HA 3.68
602600 05 HA 4.82
602600 05 HB 1.32
602600 05 HB 1.16
602600 05 HC 0.53
602600 05 HC 0.49
602600 05 HE 1.05
602600 05 HE 0.14
602600 05 KA 0.96
602600 05 KA 2.70
602600 06 HA 0.84
602600 06 KA 0.84
602600 08 HA 0.28
602600 09 HA 0.28
602600 09 KA 0.51
751100 05 CC 2.81

In the end I need one total for each possible GL,ST,RL combination.
GL ST RL Amount
602600 05 HA 8.50
602600 05 HB 2.48
602600 05 HC 1.01
602600 05 HE 1.19
602600 05 KA 3.65
602600 06 HA 0.84
602600 06 KA 0.84
602600 08 HA 0.28
602600 09 HA 0.28
602600 09 KA 0.51
751100 05 CC 2.81

There are thousands of combinations and the allocations run about 13,000
rows. I'd appreciate any help. Pivots aren't working for me on this.

Thank you!
DanaK