I have a table of 50 different KPIs. Each KPI has 3 common fields - type, audience and theme.
Each of these fields has different options within them:
Type: there after 4 different options
Audience: there are 3 different options
Theme: there are 16 different options
The goal is for me to create a helper tool that allows users to easily search for KPIs specific to their requirements rather than wade through 50 records, hoping to find ones applicable ot them. The users I tested my initial thoughts with didn't like the look and feel of slicers, pivots or the 'Filter' that you can apply to table headers.
Therefore, I want to create a series of dynamic filters so that when the user selects a option from each field, it shows the KPIs relevant to their selection/s . I essentially want something that functions like the slicer tool but looks better visually (I thought tikboxes would look nicest). users may also want to select multiple options within an attribute (eg- Type could be Process AND Risk) so I'd want the dynamic filters to be able to do that too.
Attached is a visual to hopefully help explain what i want to do.
Is this possible for a intermediate Excel user to create?
Each of these fields has different options within them:
Type: there after 4 different options
Audience: there are 3 different options
Theme: there are 16 different options
The goal is for me to create a helper tool that allows users to easily search for KPIs specific to their requirements rather than wade through 50 records, hoping to find ones applicable ot them. The users I tested my initial thoughts with didn't like the look and feel of slicers, pivots or the 'Filter' that you can apply to table headers.
Therefore, I want to create a series of dynamic filters so that when the user selects a option from each field, it shows the KPIs relevant to their selection/s . I essentially want something that functions like the slicer tool but looks better visually (I thought tikboxes would look nicest). users may also want to select multiple options within an attribute (eg- Type could be Process AND Risk) so I'd want the dynamic filters to be able to do that too.
Attached is a visual to hopefully help explain what i want to do.
Is this possible for a intermediate Excel user to create?