Difference between Subtotals and Grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

When would you use the Grouping function in order to obtain subtotals
instead of using the Subtotals function?

Thank you.
 
You probably wouldn't.

But, since it's common to use <data><subtotals> to summarize large data
lists, it's a handy feature to be able to expand/collapse the details (via
Grouping)

However, there are valid reasons to use only Grouping without subtotals. For
example, to provide an easy mechanism to show/hide parts of reports for
printing or presentation.

I hope that helps.
Post back if you have more questions

***********
Regards,
Ron

XL2003, WinXP
 
I would think that if you have a key column that can be used for categorizing
each group, then data|subtotal makes more sense.

If there is no unique identifier (per group) available, then I'd be stuck using
Data|Group. (Really, I'd find a way to add a helper column and add a unique
identifier per group.)
 
Gentlemen,

Thank you both for your replies. This is what I was looking for.

Cheers,
Helene
 
Back
Top