I have an excel workbook that shows the results of an SQL query.

In it, I have a customer number, customer name, other data, and a number of
cases ordered. Each of the rows contains a product code in it that is the
result of the query.

I would like to be able to have the user expand the subtotaled lines in it,
and see what case quantities they had on certain skus.

However, they also want it subtotaled and sorted from highest to lowest.

Col A contains the customer number, column B contains the name. Column H
contains the number of cases.

As you know, subtotaling only gives you one field you can subtotal on, and I
need the results from 2 in that line that displays with the word Total at
the end when I'm done with subtotaling.

I'm not sure how to use 2 columns as input when the subtotal function only
gives you the ability to choose one. Am I missing something here, or is
there another way to do this?

Thanks,

Steve

I can merge the cells into one cell, but cannot subtotal on that field.


"Steve Chatham" wrote in message
...
I have an excel workbook that shows the results of an SQL query.

In it, I have a customer number, customer name, other data, and a number
of
cases ordered. Each of the rows contains a product code in it that is the
result of the query.

I would like to be able to have the user expand the subtotaled lines in
it,
and see what case quantities they had on certain skus.

However, they also want it subtotaled and sorted from highest to lowest.

Col A contains the customer number, column B contains the name. Column H
contains the number of cases.

As you know, subtotaling only gives you one field you can subtotal on, and
I
need the results from 2 in that line that displays with the word Total at
the end when I'm done with subtotaling.

I'm not sure how to use 2 columns as input when the subtotal function only
gives you the ability to choose one. Am I missing something here, or is
there another way to do this?

Thanks,

Steve

You can apply the Subtotal process several times on the same range. Each
time after the first, you should uncheck the replace existing subtotals
option. You might need to experiment with the order you specify the
subtotal column to get exactly what you want.

Regards,
Tom Ogilvy

"Steve Chatham" wrote in message
...
I have an excel workbook that shows the results of an SQL query.

In it, I have a customer number, customer name, other data, and a number
of
cases ordered. Each of the rows contains a product code in it that is the
result of the query.

I would like to be able to have the user expand the subtotaled lines in
it,
and see what case quantities they had on certain skus.

However, they also want it subtotaled and sorted from highest to lowest.

Col A contains the customer number, column B contains the name. Column H
contains the number of cases.

As you know, subtotaling only gives you one field you can subtotal on, and
I
need the results from 2 in that line that displays with the word Total at
the end when I'm done with subtotaling.

I'm not sure how to use 2 columns as input when the subtotal function only
gives you the ability to choose one. Am I missing something here, or is
there another way to do this?

Thanks,

Steve