Peter Kwan

asked on

# Simple Excel problem regarding filtering

Hi Experts,

I have designed an excel to tell the distribution of various workstation types, their models at some venues.

As shown in the attached sample Excel that I have designed, we faced several problems:

While the filtering is working properly by filtering "Workstation Type", how can I make it work by filtering "Venues" (or both "Workstation Type" and "Venues"), such that I can show for the total for each workstation type.

What I mean is that I would like to show also all types of workstations in the second section (i.e. the total for each type of workstation) by only filtering "Venues".

Please be noted that I don't want to use VBA, since the Excel will be viewed also by other colleagues that are not good at Excel.

Thank you for your help.

Excel.xlsx

I have designed an excel to tell the distribution of various workstation types, their models at some venues.

As shown in the attached sample Excel that I have designed, we faced several problems:

While the filtering is working properly by filtering "Workstation Type", how can I make it work by filtering "Venues" (or both "Workstation Type" and "Venues"), such that I can show for the total for each workstation type.

What I mean is that I would like to show also all types of workstations in the second section (i.e. the total for each type of workstation) by only filtering "Venues".

Please be noted that I don't want to use VBA, since the Excel will be viewed also by other colleagues that are not good at Excel.

Thank you for your help.

Excel.xlsx

SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Hi buttersk, Thanks a lot. It is working, but can I make it to be combined into a single filter (i.e. filtering on the table above only) and the total is reflected in the pivot table also?

IrogSinta, your solution is also good, but I don't know how it can work if I select multiple venues.

IrogSinta, your solution is also good, but I don't know how it can work if I select multiple venues.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
Excel.xlsx