Difference between Subtotals and Grouping
 

Hello,

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

Thank you.

Difference between Subtotals and Grouping
 

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


"Helen" wrote:

Hello,

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

Thank you.

Difference between Subtotals and Grouping
 

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



Helen wrote:

Hello,

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

Thank you.

--

Dave Peterson

Difference between Subtotals and Grouping
 

Gentlemen,

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

Cheers,
Helene

"Dave Peterson" wrote:

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



Helen wrote:

Hello,

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

Thank you.

--

Dave Peterson