subtotal function


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
 
Ad

Advertisements

R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top