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