Analyst Crystal
New Member
- Joined
- Oct 20, 2016
- Messages
- 1
Hello everyone,
I am almost done with a large dashboard for my company, and I feel a little lost on this final touch I want to add to it.
I do not know how to attach a pic, but i will try to explain in a way that makes sense.
In my Pivot table worksheet, i can get a slicer and be able to change through out the different years, however, i want the infections in the list.
I need to be able to group the infections, since i have to drag each one, one at a time, to the Values field in the Pivot field list... or be able to add a drop down list to automatically change different infection types.
I hope i explained this in a way that made sense, if not, feel free to respond for a followup. Thanks so much, i am just drawing a blank.
<tbody>
</tbody>
I am almost done with a large dashboard for my company, and I feel a little lost on this final touch I want to add to it.
I do not know how to attach a pic, but i will try to explain in a way that makes sense.
In my Pivot table worksheet, i can get a slicer and be able to change through out the different years, however, i want the infections in the list.
I need to be able to group the infections, since i have to drag each one, one at a time, to the Values field in the Pivot field list... or be able to add a drop down list to automatically change different infection types.
I hope i explained this in a way that made sense, if not, feel free to respond for a followup. Thanks so much, i am just drawing a blank.
| Infection 1 | Infection 2 | Infection 3 | Infection 4 | |
| 2013 | 20 | 10 | 1 | 5 |
| 2014 | 40 | 20 | 2 | 6 |
| 2015 | 80 | 30 | 3 | 7 |
| 2016 | 100 | 10 | 4 | 8 |
<tbody>
</tbody>
