subtotal function
 

I have a list of item numbers, descriptions, quantity sold and few other
fields. Data looks like this

Item Description unit Cost Quantity
123 Rubberband LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3

When I sort by Item number and subtotal I get

123 Rubber band LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
123 Total 8
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3
124 Total 4

When I collapse it to subtotals only I get
123 Total 8
124 Total 4

Is there any way to include the description on the subtotal line?

gls858

subtotal function
 

You can get the names under each item number by sorting a second time.

Use something like "Count" in the Name column and *uncheck*
<Replace Current SubTotals
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"gls858" wrote in message
...
I have a list of item numbers, descriptions, quantity sold and few other
fields. Data looks like this

Item Description unit Cost Quantity
123 Rubberband LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3

When I sort by Item number and subtotal I get

123 Rubber band LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
123 Total 8
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3
124 Total 4

When I collapse it to subtotals only I get
123 Total 8
124 Total 4

Is there any way to include the description on the subtotal line?

gls858