collapsing subtotal - don't want to lose so many columns!

  • Thread starter Thread starter LHAZELTO
  • Start date Start date
L

LHAZELTO

How can I display additional columns after collapsing a
simple subtotal? For example I need a sum subtotal by
reference number but want to display the name of the group
too. Thank you.
 
So reference number and name of group both describe the same set of data (kind
of redundant).

I sometimes cheat and use a helper column:

=a2& "--" & b2

to concatenate the info I want to see. Then I use subtotal against that.

You may want to take a look at Data|pivottable, too.

You could drag both the reference number and groupname to the row field. Then
doubleclick on one of them and change subtotals to none (so you don't get both
subtotals).
 

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

Similar Threads

Subtotaling 3
Additonal info into newly created Subtotal row 1
Copying Subtotals to new worksheet 2
Collapsing all groups 0
Reference cell above in a subtotaled sheet 2
No plus or minus signs to left of subtotals 2
Collapse subtotals? 6
Subtotals 1

Back
Top