Subtotal Multiple Columns

[DanaK]

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

 

[Jacob Skaria]

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/using/excel_pivot_tables_collins.mspx


If this post helps click Yes

 

[DanaK]

Thanks, Jacob. Pivots nor subtotals can't return a single row for each unique
string without the groups/outlines which are more of a hassle to work with
for the final application of the values. My work around for this has been to
concatenate the string into one field and subtotal on that field. I was
hoping there was a formula available!