Difference between Subtotals and Grouping

H

Helen

Hello,

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

Thank you.
 
R

Ron Coderre

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
 
D

Dave Peterson

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.)
 
H

Helen

Gentlemen,

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

Cheers,
Helene
 
Top