Microsoft Excel Multiple Filters with Multiple Subtotals

[micereza]

Is there a way to filter multiple columns along with multiple subtotals. Subtotal function only allows for filtering one column with multiple subtotals.

Columns I want to filter are:

User Name
Member Type

Columns I want to subtotal are:
Quantity
Quantity %
Total $
Total $ %

To create one worksheet. Can you help?

 

[SkipVought]

Hi,

Subtotal function only allows for filtering one column with multiple subtotals.

The SUBTOTAL function returns an aggregation from a referenced range.

The Data > Subtotal... FEATURE, places subtotals in a table, and has nothing to do with FILTERING.

So I am confused about your question.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[micereza]

Thanks, figured out the problem with a fellow co-worker.

 

[SkipVought]

Would you care to share your trimuph? Other browsers may be interested in your solution.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]