Good Morning All,
New to this forum and have a question regarding pivot plots/tables and how to use some slicers to filter data. My goal is to be able to create an excel dashboard where slicers (perhaps other controls??) to manipulate tables and graphs without the user having to interact with the pivot fields.
I am tracking Key Performance Indicators per client that will be updated on a monthly basis (example lay out below)
<tbody>
</tbody>
In the pivot area, i can create a Slicer for 'Client' and vary what clients i show for KPI. I already have one table that displays all KPIs in a table (by row) and the user picks what client they want to see data for.
Is there a way to create a slicer (or other method) to filter data by KPI? For example I want a different pivot table to show clients in each row but they can select which KPI they want to see in the column. I can do this manually by adding each KPI i want to see under the values portion, but is there anyway to do this through a slicer or other type of control?
Thanks,
Erik
New to this forum and have a question regarding pivot plots/tables and how to use some slicers to filter data. My goal is to be able to create an excel dashboard where slicers (perhaps other controls??) to manipulate tables and graphs without the user having to interact with the pivot fields.
I am tracking Key Performance Indicators per client that will be updated on a monthly basis (example lay out below)
Date | Client | KPI 1 | KPI 2 | KPI 3 | KPI 4 | KPI 5 |
May-15 | Client 1 | 123 | 0.99 | 31 | .99 | .77 |
May-15 | Client 2 | 121 | 0.58 | 32 | 1 | .80 |
May-15 | Client 3 | 111 | 0.84 | 29 | .98 | .74 |
<tbody>
</tbody>
In the pivot area, i can create a Slicer for 'Client' and vary what clients i show for KPI. I already have one table that displays all KPIs in a table (by row) and the user picks what client they want to see data for.
Is there a way to create a slicer (or other method) to filter data by KPI? For example I want a different pivot table to show clients in each row but they can select which KPI they want to see in the column. I can do this manually by adding each KPI i want to see under the values portion, but is there anyway to do this through a slicer or other type of control?
Thanks,
Erik