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.