subtotal function

  • Thread starter Thread starter gls858
  • Start date Start date
G

gls858

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
 
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!
=====================================================

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
 
Back
Top